表A:
partid orderid qty
0001 123 2500
0001 234 400
...
現在想得到的結果是：
partid orderid qty
0001 123,234 2900
急！在線等！
------解决方案--------------------
- SQL code
select partid,orderid=stuff((select ','+orderid from tb where t.partid=partid for xml path('')),1,1''),qty=sum(qty)from tb tgroup by partid
------解决方案--------------------
- SQL code
select partid,orderid=stuff((select ','+orderid from tb where t.partid=partid for xml path('')),1,1,''),qty=sum(qty)from tb tgroup by partid
------解决方案--------------------
- SQL code
select partid, stuff((select ','+orderid from a where partid=t.partid for xml path('')),1,1,'') orderid, sum(qty) qtyfrom a tgroup by partid
------解决方案--------------------
- SQL code
CREATE function dbo.fn_date(@id as varchar(50))returns varchar(1000)as begindeclare @s varchar(1000)set @s=''select @[email protected]+isnull(time1,'')+';'from tb where [email protected]return (@s)endselect partid,dbo.fn_date(partid) as orderid,from Agroup by partid----------------