schoenbeck16 | SQLServerCentral

schoenbeck16

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

RE: Query to join three tables but filter out subset of the data

CELKO (12/13/2016)
>> For simplicity sake, say we have the following tables:<<
It would have been simpler if you posted real DDL, complete with constraints keys and references. What we have here...

December 14, 2016 at 10:05 am

#1917952
RE: Query to join three tables but filter out subset of the data

Chris Harshman (12/9/2016)
schoenbeck16 (12/9/2016)
...
I don't think this one will work as is, since the variable will only hold the last value selected.
OK, I thought there was only 1 row in...

December 12, 2016 at 8:18 am

#1917390
RE: Query to join three tables but filter out subset of the data

Chris Harshman (12/9/2016)
It's difficult to tell without knowing the indexes on these tables, but I'm thinking Steve's query is more expensive since it's hitting all 3 base tables twice, and...

December 9, 2016 at 8:34 am

#1917086
RE: Query to join three tables but filter out subset of the data

Thank you sir, this works great!

December 9, 2016 at 8:33 am

#1917085

Viewing 4 posts - 1 through 4 (of 4 total)