Home Forums SQL Server 2005 T-SQL (SS2K5) Convert CSV values in three columns to rows RE: Convert CSV values in three columns to rows

  • October 2, 2010 at 12:36 am

    #1230660

    But as Oleg said for larger element count the Tally is not usable.

    For the 16 element on my machine the Tally runs about 1 se. and the CLR RegEx about 20 sec.

    For 100 elements the Tally runs 20550 ms and CLR RegEx 26773 ms.

    But the situation differs with increased number of element. Tested it on 1333 elements (nearly 8k). The Tally table version I stopped after 19 minutes of execution time.

    Thanks for the feedback... I'll run your code and see if I come up with the same results.

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