대략 이런 건 어떠세요?

http://www.sqlleader.com/mboard.asp?exec=view&strBoardID=SS2005CLR&intPage=1&intCategory=0&strSearchCategory=|s_name|s_subject|&strSearchWord=&intSeq=2937

이런 방법들을 원하시는건가요?

http://www.sqlleader.com/mboard.asp?exec=view&strBoardID=SS2005TSQL&intPage=1&intCategory=0&strSearchCategory=|s_name|s_subject|&strSearchWord=&intSeq=972

그중에 3번 활용해서 해봤습니다.

WITH TBL1 AS
(
 SELECT 'Assembly' AS asset_type, '0000000864' AS b_cd, '0210' AS bay_no UNION ALL
 SELECT 'Assembly', '0000000864', '0211' UNION ALL
 SELECT 'Assembly', '0000000864', '0212' UNION ALL
 SELECT 'Assembly', '0000000864', '0306' UNION ALL
 SELECT 'Assembly', '0000000864', '0307' UNION ALL
 SELECT 'Assembly', '0000000864', '0308' UNION ALL
 SELECT 'Assembly', '0000000864', '0309'
)

SELECT DISTINCT asset_type
 , b_cd
 , STUFF((SELECT ',' + bay_no FROM TBL1 AS B WHERE B.asset_type = A.asset_type AND B.b_cd = A.b_cd FOR XML PATH('')), 1, 1, '')AS bay_no
FROM TBL1 AS A

  FOR XML PATH는 2005부터 지원합니다.

정말 고맙습니다. FOR XML PATH 로 해겼했습니다. 

도움 주셔서 정말 감사합니다.