asked
get year dates stored procedure
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.
If you are passing the year to the stored procedure and wish to return that year plus any years greater than that year simply have the where statement state >= @year.
Thanks Tim that was simple, I way over did that with the while counter.
13 People are following this question.
