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