Home Forums SQL Server 2008 T-SQL (SS2K8) Recursion with a Twist RE: Recursion with a Twist

  • November 28, 2012 at 3:27 pm

    #1563488

    Alan.B (11/28/2012)

    Evil Kraig F (11/28/2012)

    This is NOT pretty, but it IS functional.

    I am trying to understand why went with a loop vs a set-based approach. I posted a more set based method earlier that gets the same results notably faster. I am not trying to be confrontational, I'm just trying to understand your approach or what I did wrong.

    @Alan.b If i look at your method correctly it misses InvoiceID 3.

    @Kraig your right about the issues with my method that you cant go both directions up the tree which i had forgotten about. (dont work with hierarchies much)

    EDIT: i sat to long to hit the post button so struck what was said before the post.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]