Lynn Pettis (3/17/2013)
So, does the extra typing make it more complex? I think it makes the query more understandable.
Extra typing always makes anything more complex.
By definition.
More typing - more reading - longer parsing.
Even if it's insignificant by your opinion - it's still more, not less.
As for "more understandable" - it's totally a matter of habit.
For me - it's another way around.
Especially when it comes to multi-layer DT's.
But if to ingnore our personal preferences - the query written using DT is simpler than the same query written using CTE.
😎
_____________
Code for TallyGenerator