SQl server2008-split delimited values into three rows

• arubala75

  Grasshopper

  Points: 23

  More actions

  July 6, 2012 at 9:36 am

  #392681

  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

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

  5032401 BSS Engineering

  NOC Network

  Operations Cable

  we have to ingore null values as well.

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

  Thanks and Regards,

  Aru

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 6, 2012 at 11:06 am

  #1509809

  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]