Completely agree with your recommendations on the blogs for info on CTE and a lot of other stuff. Your posts have always been very helpful and I have the privilege of working with Denis every day at Dow Jones and he definitely know his stuff. It's a lot of fun to be writing C# apps on the front end when Denis is your DBA and can turn you on to alternate ways of approaching some interesting data challenges.


>>Some good blogs to read about cte:
>>
>>CTE: Coolest T-SQL Enhancement - Blog by Brad Schulz
>>
>>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-advent-2011-recap - summary blog by Denis Gobo (cte is day 5), you may find each day to be of interest
>>
>>And, of course, my own blog
>>CTE and hierarchical queries

You're lucky! Denis indeed knows his stuff. He published more than 400 blogs with most of them on various SQL topics.