Monthly Archives: January 2013

List of years in SQL Server

Posted on by

Here is a CTE from my friend Phil that returns a list of years in an efficient manner. Good reference.

/*Return a list of years since 2009*/

WITH    yearlist
      AS ( SELECT   2009 AS year
           UNION ALL
           SELECT   yl.year + 1 AS year
           FROM     yearlist yl
           WHERE    yl.year + 1 <= YEAR(GETDATE())
         )
SELECT  year
FROM    yearlist
ORDER BY year DESC;