Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amit Gaur Convert String to a Table using CTE RE: Convert String to a Table using CTE

  • May 13, 2011 at 4:36 pm

    #1324579

    phickey (5/13/2011)

    msaleem-583379 has a pretty good function.

    Where is that? What is the URL? I don't see such an entry on this thread.

    And, for the record, the "performance issue" with the Tally Table has very successfully been put to bed for VARCHAR(8000) and NVARCHAR(4000). Please see the following article...

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    And, yes, I realize I'm responding to a post that is responding to a two year old thread. 😉

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