函数的简单应用(原帖地址:http://topic.csdn.net/u/20090317/16/c7f5c2e3-293d-4d67-85be-0a4a17d52855.html)

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