How to split the values in sqlserver 2008

damodara naidu betha

Rate me:

0.00/5 (No votes)

3 Oct 2012CPOL

Hi Nanda Kishore, Try this code blockWITH SplitCTE AS (SELECT CAST('' + REPLACE(DelimitedColumn, ',','') + '' AS XML) AS StringsFROM YourTableName WHERE )-- Xquery to get the desired result set using CROSS JOINSELECT SUBSTRING(x.i.value('.',...

Revisions

Compare	Revision	Minor	Date	Status	Editor
	2 - publicly available	No	3-Oct-12 0:09	Available	damodara naidu betha
Updates in content. 6 changes had been made.
	1	No	3-Oct-12 0:06	Available	damodara naidu betha

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

damodara naidu betha

Software Developer (Senior)

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

How to split the values in sqlserver 2008

Revisions

License

Comments and Discussions