select partid,orderid=stuff((select ','+orderid from tb where t.partid=partid for xml path('')),1,1''),qty=sum(qty)
from tb t
group 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 t
group by partid

------解决方案--------------------
SQL code

select partid,
       stuff((select ','+orderid from a where partid=t.partid for xml path('')),1,1,'') orderid,
       sum(qty) qty
from a t
group by partid

------解决方案--------------------
SQL code
CREATE function dbo.fn_date(@id as varchar(50))
returns varchar(1000)
as   
begin
declare @s varchar(1000)
set @s=''
select @s=@s+isnull(time1,'')+';'
from tb where partid=@id
return (@s)
end



select partid,dbo.fn_date(partid) as orderid,
from A
group by partid

----------------