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

  • May 21, 2010 at 6:12 am

    #1170760

    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.

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]