lucassouzace
SSC Eights!
Points: 907
More actions
October 2, 2008 at 2:33 pm
#103594
over gain... When i'm using CTE And Sub-Queries? 🙁
Jack Corbett
SSC Guru
Points: 184394
October 2, 2008 at 7:05 pm
#880249
I'm not sure what your question is, but in most instances you can use either a CTE or a subquery and similar performance. I have learned to use CTE's because I think they are easier to read than using a subquery as a derived table.
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply