求1動態SQL語句

求一動態SQL語句？
表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 @s=@s+isnull(time1,'')+';'from tb where partid=@idreturn (@s)endselect partid,dbo.fn_date(partid) as orderid,from Agroup by partid----------------