表1 showcode proccode
----------------------------------------------------------
A001 A
A001 B
A002 A
A002 C
结果
showcode proccode
----------------------------------------------------------
A001 A ,B
A002 A,C
SQL语句
SELECT showcode ,
ProdCode = STUFF(( SELECT ',' + prodcode
FROM tb a
WHERE a.ShowCode = b.showcode
FOR
XML PATH('')
), 1, 1, '')
FROM tb b
GROUP BY showcode