Home Forums SQL Server 2008 T-SQL (SS2K8) Solve Problems Using Recursive CTE RE: Solve Problems Using Recursive CTE

  • December 5, 2012 at 4:39 pm

    #1565965

    bj_shenglong (12/5/2012)

    But I assume this way could be faster...

    That's how rumors of performance get started. 🙂

    Write code to build a million row test table and test your hypothesis. No matter which way it turns out, we'll all learn something if you post the results. See the following articles for how to do such a thing pretty easily and quickly.

    http://www.sqlservercentral.com/articles/Data+Generation/87901/

    http://www.sqlservercentral.com/articles/Test+Data/88964/

    --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)