SELECT A.ID,
Split.a.value('.', 'VARCHAR(100)') AS CSVData
FROM
(
SELECT ID,
CAST ('' REPLACE(CSVData, ',', ' ') ' ' AS XML) AS CSVData
FROM myTable
) AS A CROSS APPLY Data.nodes ('/Node') AS Split(a)
Split.a.value('.', 'VARCHAR(100)') AS CSVData
FROM
(
SELECT ID,
CAST ('
FROM myTable
) AS A CROSS APPLY Data.nodes ('/Node') AS Split(a)
سید حامد واحدی
18 آذر 1395