Eugene Elutin (3/18/2013)
:w00t::w00t::w00t::w00t::w00t:"extra words" is a greatest argument to declare a "code" winner I'have ever seen.
Did you find anything else different?
Anything?
If you missed it - I responded on this statement:
Lynn Pettis (3/17/2013)
Really, CTEs are complex? I find them to make writing queries easier as you don't have to write derived tables.
So, I compared those 2 ways of writing queries.
Having no other points of differece, less typing makes DT queries easier to write.
Extra typing always makes anything more complex.
By definition.
There is no such definition! Actually, the opposite is quite more common.
Opposite is stupid.
Smeh bez prichiny - priznak durachiny.
If you you do typing in sake of typing - you're wasting your time and wasting time of those who read it (including SQL optimizer).
There must be a reason to add an extra line to a code.
Inline documentation, better formatting, whatever else - everytime there must be a reason.
I cannot see any advantage of that particular extra line.
Can you point on it?
From my experience, most of developers finding CTE is much more clear way to write query and therefore less complex then using "derived tables".
Most developers used to wrire "CSS style" code.
CTE fits there patterns and allows not to learn SQL-specific best practices.
That's why it's so popular.
_____________
Code for TallyGenerator