DECLARE @str varchar(8000)
SET @str = '10,2,3,4,5,6,7,8,9'
DECLARE @InputString varchar(8000)
SELECT @InputString = ',' + @str + ','
;with qry(n, names) as
(select len(list.names) - len(replace(list.names, ',', '')) - 1 as n, substring(list.names, 2, len(list.names)) as names
from (select @InputString names) as list
union all
select (n - 1) as n,
substring(names, 1 + charindex(',', names), len(names)) as names
from qry
where n > 1)
select substring(names, 1, charindex(',', names) - 1) dwarf
from qry;
DECLARE @str varchar(8000)
SET @str = '10,2,3,4,5,6,7,8,9'
DECLARE @InputString varchar(8000)
SELECT @InputString = @str + ','
;WITH RecursiveCSV(x,y)
AS
(
SELECT
x = SUBSTRING(@InputString,0,CHARINDEX(',',@InputString,0)),
y = SUBSTRING(@InputString,CHARINDEX(',',@InputString,0)+1,LEN(@InputString))
UNION ALL
SELECT
x = SUBSTRING(y,0,CHARINDEX(',',y,0)),
y = SUBSTRING(y,CHARINDEX(',',y,0)+1,LEN(y))
FROM
RecursiveCSV
WHERE
SUBSTRING(y,CHARINDEX(',',y,0)+1,LEN(y)) <> '' OR
SUBSTRING(y,0,CHARINDEX(',',y,0)) <> ''
)
(select x FROM RecursiveCSV)
OPTION (MAXRECURSION 32767);
'게임개발 > 팁' 카테고리의 다른 글
| MSSQL 에서 in 사용시 varchar를 파라메터로 넣기 (0) | 2013.03.22 |
|---|---|
| 비트맵폰트용 일본어 (0) | 2011.07.14 |
| 클립보드에 텍스트 넣기/빼기 (1) | 2007.02.14 |
| 서브버전 로그 꼭 남기게 하는 팁 (2) | 2007.01.05 |
| synchronized block in C++ (0) | 2006.05.03 |
| 최상위 비트 인덱스 가져오기 (0) | 2006.05.02 |