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 5:06 am

    #1630733

    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?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden