mssql 열을 가로로 출력

WITH TB AS(

 SELECT 1 SEQ , '사과' AS ITEM
 UNION ALL
 SELECT 1 SEQ , '포도' AS ITEM
 UNION ALL
 SELECT 2 SEQ , '바나나' AS ITEM
 UNION ALL
 SELECT 2 SEQ , '망고' AS ITEM
 UNION ALL
 SELECT 3 SEQ , '복숭아' AS ITEM

)

SELECT DISTINCT A.SEQ
  , STUFF((
      SELECT ',' + CONVERT(VARCHAR(50), B.ITEM)
      FROM TB AS B
      WHERE A.SEQ = B.SEQ
      FOR XML PATH('')
      ), 1, 1, '') AS ITEM
FROM TB AS A

--------------------------------------------------------------
결과
--------------------------------------------------------------
1 사과,포도
2 바나나,망고
3 복숭아