SQL Kiwi (12/6/2011)
Hugo Kornelis (12/6/2011)
Something about the ability to select blocks of code to run easily I think is one main argument in favour.
+1000
I work mainly with 1000+ lines procs for reporting. CTEs just don't do what I need. I often need to nest 2-3 levels and I need to "inner" select as many as I need as to not go insane.