Home Forums SQL Server 2008 SQL Server 2008 - General Split String with row terminator RE: Split String with row terminator

  • March 16, 2014 at 3:57 pm

    #1697521

    born2achieve (3/16/2014)

    Hi Adi, thanks for your reply, sample and appreciate your time on this post.

    Hi Jeff,

    Thanks for your reply

    So from your statement it's not good to use the function which i mentioned because of the performance impact. I understand. How about Adi's Suggestion. Logically it works with my data. is there any performance impact on this suggestion.

    Please suggest me

    No... it's not good to use the function because the changes you said Aaron made are not sufficient for what it's supposed to do. It could return wrong or truncated information without you ever knowing about it.

    As for Adi's suggestion, I'll have to take a look.

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