Home Forums SQL Server 2005 T-SQL (SS2K5) spliting nested string RE: spliting nested string

  • May 22, 2010 at 11:43 am

    #1171245

    Atif Sheikh (5/21/2010)

    Anamika (5/21/2010)

    Hi,

    Thanks for the inputs. both are working fine

    thanks,

    regards,

    Ami

    If the comma separated list is as long as 1000s of list items, it would be better to with tally table solution. But if it is limited to 10s or 20s. then its up to you both are feasible.

    I have to disagree... limited row counts are never justification for writing something that isn't scalable.

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