Some kind of weird glitch on UT. My first post in reply to your blog recommendations is below but up 2 on this thread is a reply from me with nothing and then the next message is may actual reply incorrectly shown as a post from you replying to me.

Folks this was me agreeing with Naomis recommendations and and saying her posts had been helpful, not Naomi thanking herself <s> First time I've seen this happen but since my reply nothing in it also showed no buttons on the bottom to fix it and then the next message looked like it came from Naomi thought I should straighten it out. (and re-reading this I realize I probably haven't done that)

Anyway, go to Less than Dot and read all the blogs - they're great .


>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.