create TABLE TT (id varchar(32),type varchar(32),billMoney decimal(12,2))
INSERT INTO TT
SELECT '10001','支票',2000
UNION ALL
SELECT '10001','预留款',1000
UNION ALL
SELECT '10001','现金',800
UNION ALL
SELECT '10002','挂账',1000
UNION ALL
SELECT '10002','现金',800
create function dbo.FC_Str(@id int)
returns varchar(1000)
as
begin
declare @str varchar(1000)
set @str=''
select @str=@str+','+type+':'+cast(billMoney as varchar) from TT where id=@id
return stuff(@str,1,1,'')
end
select id,sum(billMoney) payedMoney,dbo.FC_Str(id) from TT group by id
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/ws_hgo/archive/2009/03/17/3999390.aspx