sqlserver2008 Split String _mssql2008

--Note: For example, the following data

ID Id_value
-----------------
1 ' aa,bb '
2 ' AA,BB,CC '
3 ' AAA,BBB,CCC '

--Convert to the following format
ID Id_value
-----------------
1 ' AA '
1 ' BB '
2 ' AA '
2 ' BB '
2 ' CC '
3 ' AAA '
3 ' BBB '
3 ' CCC '

--Code-------------------------------------------Go

Copy Code code as follows:

CREATE table Ta
(
ID int,
id_value varchar ()
)

INSERT INTO TA
Select 1, "AA,BB ' union All"
Select 2, ' AA,BB,CC ' union ALL
Select 3, ' AAA,BBB,CCC ' br>
Select
Top 4000 IX = identity (int, 1, 1)
to #tb
from sys.objects A, sys.objects b

select
ID,
Id_value = substring (id_value,ix,charindex (', ', Id_value + ', ', ix)-IX "
from TA as A, #tb as B
WHERE SUBSTRING (', ' + Id_value, IX, 1) = ', '

drop table ta
drop table #tb