Post reply

sql server2008 query- To split the delimited values in the table ibnto multiple rows

  • July 6, 2012 at 9:53 am

    #277409

    Hi,

    Iwould like to have the delimited values in one of the columns in sql server table to be split into three rows.

    ex: Project id Teams Impacted

    5032401 BSS;NOC;Operations;Engineering;Network;Cable

    as below having 3 * 8 blocks having values like col1 and col2 below.

    Project id : Team1 Team2 team 3 Team4 team5 team6 team 7 team 8

    5032401 BSS Engineering x

    NOC Network y

    Operations Cable z

    we have to ingore null values as well for the project ids which does not have teams impacted.

    Any help regarding this is greatly appreciated. Please suggest at the earliest.

    Thanks and Regards,

    Aru

  • July 6, 2012 at 11:12 am

    #1509812

    I would suggest reading Jeff Moden's aticle here on SSC at:

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

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 6, 2012 at 12:00 pm

    #1509838

    bitbucket-25253 (7/6/2012)

    I would suggest reading Jeff Moden's aticle here on SSC at:

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

    Making it a clickable link. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • July 10, 2012 at 1:14 pm

    #1511154

    Thanks for the post. I will check and revert back.

    Thanks and Regards,

    Aru

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply