Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Response to query
Message
From
06/04/2007 02:51:34
 
 
To
06/04/2007 02:46:41
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01212334
Message ID:
01212889
Views:
23
That does not backup your claim about single table read vs multiple table reads. I can't see your claim being substantiated. As for your test, time does not say me anything. What does the profiler say ??

Sorry, my mistake, I was wrong about that, they're both hitting the invoice table twice. Jury will disregard. (I still prefer the CTE approach for readability, though I realize that can be a subjective thing).

I'll get back to you tomorrow with what the profiler says.
Previous
Reply
Map
View

Click here to load this message in the networking platform