라이브러리/시스템

Convert multiple rows into one row - SQL Server

눌프 2011. 7. 13. 16:20
SELECT CONVERT(
VARCHAR(128),
(
SELECT AppID + ','
FROM (
select Value AS AppID from FN_Split('1,2,3', ',')
) A FOR XML PATH('')
)
)