一个存储过程实例，慢慢再加注释吧！仅供自己学习

USE [rfiddbHFKT]
GO
/****** Object:  StoredProcedure [dbo].[ppque_tu]    Script Date: 07/21/2017 23:36:40 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[ppque_tu]              
(            
  @fdatebegin  varchar(50),  ---开始日期            
  @fdateend      varchar(50),  ---结束日期            
  @linename   varchar(50),  ---生产线            
  @zhandian   varchar(50),  ----站点            
  @banci   varchar(50),       ---班次            
  @strnum varchar(5)           ----数量  默认数量是10            
)            
AS                
  declare @sqltext varchar(1500)                
  declare @fcount int             
  declare @sumTotal int           
  ---缺陷饼图              
              
  --生成临时表              
  create table #que_cx(              
    class_name nvarchar(200),              
    sernsum int,          
     rate decimal(18,2))              
              
  --统计数据 添加查询条件              
    insert into #que_cx(class_name,sernsum)              
    select c.class_name, count(c.class_name) as sernsum                
    from tjianyan a,tsaomiao b, z_que_class c               
    where a.sern = b.sern and a.zd_bh = b.zd_bh and a.que_class = c.class_id               
      and a.ddate  between convert(datetime,@fdatebegin,120)           
    and convert(datetime,@fdateend,120)         
    and(case when @linename='' then 1 else CHARINDEX(@linename,b.linename) end)>0               
     and  a.zd_bh like '%'+@zhandian+'%'    
     and(case when @banci='' then 1 else CHARINDEX(@banci,a.bc_id) end)>0               
     group by c.class_name order by sernsum desc                
       
  --如果小于设置数量 不显示其余项          
  select @sumTotal=sum(sernsum) from #que_cx          
  select @fcount = count(*) from #que_cx          
   update #que_cx  set rate=sernsum*1.00/@sumTotal * 100  
        
  if @fcount>@strnum             
      set  @sqltext = 'select top ' + @strnum + '  class_name,''a'' as aa,sernsum,rate  from  #que_cx  '               
                       +' union '              
                       +' select  ''其余项'' as class_name ,''b'' as aa, isnull(sum(sernsum),0) as sernsum,sum(rate)  from  #que_cx '               
                       +' where class_name not in ( select top ' + @strnum + '  class_name from  #que_cx ) '      
                      +'  order by aa,sernsum desc'               
   else             
          set  @sqltext = 'select  class_name,''a'' as aa,sernsum,rate  from  #que_cx  '               
                       +' order by aa,sernsum,rate  desc'               
                                   
exec(@sqltext)