Display Years

actually i have a table year. in that, MonthId,Monthname,CreateDate parameters are there. now i want to save values from 2014 to 2030 by using stored procedure.

now you can understand

Hi!

Sorry,I didn't get your question properly but here is the query to get next year or how many of year next to current year you want to get, you just add number in query then you will get the next year ..

select CONVERT(datetime, CONVERT(VARCHAR(20), YEAR(GETDATE())+15) + '.01.01')

Need to dispaly years.....

for example, i need to display 2014 to 2030