USE [WSJDZX_GHR]
GO
/****** Object: StoredProcedure [dbo].[PR_GetYear] Script Date: 11/14/2016 11:54:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[PR_GetYear] @t1 int,@year1 varchar(4),@year2 varchar(4),@sql varchar(8000)
AS
set @sql= ' '
set @year1=year(getdate())
set @t1=-10
while @t1> =-10 and @t1 <=10
begin
set @year2=@year1+@t1
set @sql=@sql+ 'select '+@year2+ ' [year] union all '
set @t1=@t1+1
end
set @sql=substring(@sql,1,len(@sql)-10)+ 'order by [year] '
print substring(@sql,1,len(@sql)-10)
exec (@sql)