SQl server2008-split delimited values into three rows

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » SQl server2008-split delimited values into...

SQl server2008-split delimited values into three rows

Rate Topic

Display Mode

Topic Options

Author

Message

arubala75

Posted Friday, July 06, 2012 9:36 AM

Forum 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

bitbucket-25253

Posted Friday, July 06, 2012 11:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 5,123, Visits: 20,369

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 »

Permissions