sql server 2005 A字段相同数据的B字段合并
摘要：
如图，写出查询语句结果为查询语句为：select difficultName , (STUFF((select ';'+area FROM MoneyAndArea WHERE difficultName=b.difficultName ORDER BY difficultName FOR XML PATH('')),1,1,'')) AS area, (STUFF((select ';'+[money] FROM MoneyAndArea WHERE difficultName=b.difficultName ORDER BY 阅读全文
posted @ 2012-02-04 10:44 MyBeN 阅读(1929) 评论(0) 推荐(0) 编辑
