Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Tally OH! An Improved SQL 8K “CSV Splitter” Function Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

  • May 2, 2011 at 7:27 am

    #1318388

    Gianluca Sartori (5/2/2011)

    Jeff, your article is great!

    The final splitter function could have been 3 times slower than the original one, and the article would have been memorable anyway. It's a tale of stubborn resistance to surrender and a "thinking outside the box" lesson for all of us.

    Thank you very much.

    I'm humbled by your observation, Gianluca. :blush: I didn't think that anyone would understand that especially with the silly and fun metaphors I made about my angst on the subject. In real life, it was killing me that the original function performed so terribly on the high end of strings and I had to either fix it or apologize for it. Thank you for the very kind words.

    For the record, I really do have the artwork with the cat in the box. I commissioned a friend to make it for me several years ago to remind me that "Before you can think outside the box, you must first realize... you're in a box!"

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