Data Management - Latest Comments on T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Mike Donnelly [Visitor] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Mike Donnelly [Visitor] — Fri, 30 Mar 2012 12:42:56 +0000

I've used Recursive CTE's before and I usually get them to do what I want, but I always have to twist my brain to try and figure out how it is going to work. This week I decided I wanted to grok how they worked. I started reading through a couple blog posts a day until I could find one that would make it click for me. This is the best explanation I have found. I just wish I had started at the bottom of the list and read it on Monday.

Andy [Visitor] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Andy [Visitor] — Tue, 10 May 2011 19:16:31 +0000

Thanks Jes, really good post and something which I reckon I'll use. Sometimes difficult to find SQL stuff that isn't beginner or expert, and for me this sits perfectly in the middle. Will have to re-read again tomorrow though to understand it all properly!

Brad Schulz [Visitor] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Brad Schulz [Visitor] — Tue, 10 May 2011 18:33:45 +0000

Hi Jes...

The title of your post reminded me of the title I used for a post on Recursive CTE's last year:

http://bradsruminations.blogspot.com/2010/03/this-article-on-recurson-is-entitled.html

I guess we Schulzes are on the same wavelength. 8^)

--Brad

Bob Pusateri [Visitor] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Bob Pusateri [Visitor] — Tue, 10 May 2011 18:04:37 +0000

Excellent post - I really enjoyed this. Had never messed with MAXRECURSION before so I totally learned something too! Thanks so much for contributing to T-SQL Tuesday!

Bradley Ball (@SQLBalls) [Visitor] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Bradley Ball (@SQLBalls) [Visitor] — Tue, 10 May 2011 17:49:11 +0000

Great Blog Jes!

Jason Yousef [Visitor] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Jason Yousef [Visitor] — Tue, 10 May 2011 17:10:11 +0000

Thanks

Naomi Nosonovsky [Member] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

Naomi Nosonovsky [Member] — Tue, 10 May 2011 12:15:31 +0000

Kendra Little has a good blog on the performance implications of this method

Filling in Data Potholes Redux: Tally Tables vs CTEs

David Forck (thirster42) [Member] in response to: T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

David Forck (thirster42) [Member] — Tue, 10 May 2011 12:06:55 +0000

great blog, and congrats on figuring out the recursive cte. it took me a while to figure those out.