多条记录合并成一个单元格(转换成XML)
本帖最后由 笒羽 于 2017-4-6 10:38 编辑select *,(select itemname as c from qz_item where parentid=a.id for xml path('')) as childitems from qz_item as a where parentid=0
stuff((select ','+ProductName+'×'+convert(nvarchar(50),BuyNum) from tablename where antiorderid=a.id for xml path('')),1,1,'')
页:
[1]