Hi I have question about the best way to get multiple year dates based on the Year I select in my stored procedure. I declared a table variable and inserted years 2008 through 2014. So for example when I select year 2008 in my SP, I want to receive all the years 2008 through 2014. If I select year 2010 I will get 2010 through 2014 and if I select 2013, I will get 2013 through 2014 etc. Also What I have done is created a while counter but it does not work the way I want it because it does not start with the year I selected. Below Is what I have.... *set @year = 2010 set @year = @year while @year < 2014 begin SET @year = @year + 1 select @year as FISCAL_YEAR end* Any help or other ideas would be appreciated. Thanks in advance.