Home Forums SQL Server 2008 SQL Server 2008 - General Extract text which is between 1st and 2nd comma RE: Extract text which is between 1st and 2nd comma

  • February 13, 2014 at 11:36 am

    #1688878

    pruthvi116 (2/13/2014)

    Thanks for both the functions!! Both of them were extremely useful.

    My recommendation would be to avoid any and all functions, especially split functions, that contain the words "WHILE" or "BEGIN". That would make them either Scalar or Multi-Statement functions that will rob your application of performance and use way more resources than they ever should.

    Please see the following article for a demonstration of exactly what I'm talking about.

    http://www.sqlservercentral.com/articles/T-SQL/91724/

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