统计年龄段的（存储过程）

 USE [YunNanHuanWei]

    
 GO
    
 /****** Object:  StoredProcedure [dbo].[UserAge]    Script Date: 05/23/2018 13:24:43 ******/
    
 SET ANSI_NULLS ON
    
 GO
    
 SET QUOTED_IDENTIFIER ON
    
 GO
    
 ALTER proc [dbo].[UserAge]
    
 (
    
 --多个年龄段，18-30,30-40,40-50,50-60
    
 @agestr nvarchar(500),
    
 @departid  nvarchar(50),
    
 @cusid nvarchar(50)
    
 )
    
 as
    
 begin
    
 declare @s nvarchar(50)
    
   CREATE TABLE #tt(
    
   [Number] int NOT NULL,
    
 	[Age] [nvarchar](200) NOT NULL,
    
 )
    
 while(charindex(',',@agestr)<>0)
    
  begin