All Questions
Tagged with temporary-tables join
6 questions
0
votes
1
answer
371
views
Querying an enormous table (~150 million rows) with multiple joins - SQL Server
First off, I don't have SHOWPLAN permission on this server or permission to add indexes, etc. I am not a database administrator by trade; I'm just trying to query a database. There is already indexes ...
0
votes
0
answers
134
views
Why does UNION fail here?
I have a problem that I can't seem to figure out how to fix.
What I want to do is simple, select data and append a row of sums as the last row. But I keep getting the error
An error occurred in ...
- 165
0
votes
2
answers
2k
views
INNER JOIN is extremly slow on some rows and create temp table
The MySQL query
SELECT `p`.*,
`p.Author`.*
FROM `post` AS `p`
INNER JOIN `user` AS `p.Author` ON `p`.`userid` = `p.Author`.`userid`
WHERE ( ( `p`.`threadid` = 29780 )
AND ( `...
- 151
0
votes
1
answer
44
views
How to get the consolidated ServiceID with the sum of File Size associated with over an year
Can anyone please help me on below to get the consolidated ServiceID with the sum of File Size associated with it over an year.
Complete Code (For reference)
If(OBJECT_ID('tempdb..#temp1') Is Not ...
- 1,600
0
votes
1
answer
1k
views
Postgresql using LEFT JOIN and RIGHT JOIN at the same time
I have two temporary tables that I have created using tampa, tampb clauses in PostgreSQL. I want to be able to get result when data from either side is missing (company1 or company2) but not both.
I ...
- 141
2
votes
1
answer
9k
views
Massive joins Vs Updating temp table
I'm working on a query that essentially aggregates a slew of tables together.
The first method I tried was to inner join all of the tables into one nice big query that pretty much looked like this:
...
- 207