Home Forums Article Discussions Article Discussions by Author Discuss content posted by Lokeshkumar SQL Function to Split Comma Separated Values and Insert into Table RE: SQL Function to Split Comma Separated Values and Insert into Table

  • December 3, 2010 at 8:28 pm

    #1258707

    WayneS (12/1/2010)

    chris-860960 (11/30/2010)

    Just switched to WayneS' non-RBAR function. Now that's FAST!

    It's not "my" function - it comes from Jeff Moden. It's just what is in use around here, with little tweaks here and there to make it as fast as it possible can be.

    Thanks for the kudo but it's not my original idea, either. It's an assembly of good practice from many authors with many lessons learned. Many others have have put together similar functions.

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