Home Forums Article Discussions Article Discussions by Author Discuss content posted by Svetlana Marinova Using a Recursive CTE to Generate a List RE: Using a Recursive CTE to Generate a List

  • July 9, 2013 at 7:41 am

    #1630797

    ChrisM@Work (7/9/2013)

    Beautifully illustrated, well written and easy to follow. Even though the rCTE method has been shown more than once to be somewhat slower than FOR XML PATH, there are some good ideas here.

    I wonder if this method really is faster than a properly-written cursor?

    I wonder how it compares to using a quirky update in a function?

    +1 @chrism-2

    Thank you for the article. This was a very nice read and I am a big fan of rCTE's. Chris kind of summed up what I wanted to say (although I always forget about the quirky update) :hehe:


    Everything is awesome!