SQL 多行合并为1行 需要写函数

 select * from formtable_main_20
sp_help formtable_main_20
--drop view zcountQJ01
create view zcountQJ01
as
select appman ,year(startdata) as zyear,jb,cast(sum(num) as decimal(4,1) ) as num
from formtable_main_20
where year(getdate()) = year(startdata)
group by appman,jb,year(startdata)
select * from  zcountQJ01
 
 
--drop function fn_str
  --创建函数
  CREATE   function   dbo.fn_strqj(@var_appman   int)  
  returns   varchar(100)  
  as    
  begin  
        declare   @var   varchar(100)  
        set   @var=''  
        select   @var=@var+
       -- cast(jb  as   varchar(10))
       case jb
           when 0 then '事假'
           when 1 then '病假'       
           when 2 then '婚假'
           when 3 then '丧假'
           when 4 then '哺乳假'
           when 5 then '探亲假'       
           when 6 then '公休假'
           when 7 then '年假'
           when 8 then '其他'
           when 8 then '护理假'
       end 
    +':'+cast(num  as