SELECT 编号
,STUFF((SELECT ','+名称 FROM tablename AS B WHERE a.编号=b.编号 FOR XML PATH('')),1,1'')
FROM tablename AS A
GROUP BY 编号
,STUFF((SELECT ','+名称 FROM tablename AS B WHERE a.编号=b.编号 FOR XML PATH('')),1,1'')
FROM tablename AS A
GROUP BY 编号
调试欢乐多
合并行数据,上面链接可参考一下~~!
,STUFF((SELECT ','+名称 FROM tablename AS B WHERE a.编号=b.编号 FOR XML PATH('')),1,1,'')
FROM tablename AS A
GROUP BY 编号
搞定,谢谢!结贴.