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.
Any help or other ideas would be appreciated. Thanks in advance.
asked Mar 20, 2013 at 02:43 PM in Default