Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, July 06, 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
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
Post #1326178
Posted Friday, July 06, 2012 11:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:05 PM
Points: 5,472, Visits: 23,551
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

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

Add to briefcase

Permissions Expand / Collapse