Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQl server2008-split delimited values into three rows Expand / Collapse
Posted Friday, July 6, 2012 9:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 20, 2012 9:14 AM
Points: 5, Visits: 8

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,
Post #1326178
Posted Friday, July 6, 2012 11:06 AM



Group: General Forum Members
Last Login: Sunday, January 4, 2015 7:55 AM
Points: 5,333, Visits: 25,280
I would suggest reading Jeff Moden's aticle here on SSC at:

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


Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1326223
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse