Home Forums SQL Server 2008 T-SQL (SS2K8) Flattening a Parent Child Hierarchy RE: Flattening a Parent Child Hierarchy

  • January 14, 2013 at 4:33 pm

    #1577115

    codeplexer (1/13/2013)

    Oops, I should have say "I think this is a better way...." You can find your proof easily if you know copy and paste. But SQL newbie would have know straight forward SQL join or left join is faster than recursive cte and a lot of extra code.... Just saying

    Tell ya what. YOU do the copy and paste to support your own claim! Build a nice little 100,000 node hierarchy and prove what even a newbie knows... that a developer must not guess like you have. 😉

    Where's the code that compares the runs and where's the code that builds the test data so that others can test?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)