Trying to setup a SQL Azure Data Sync Group.
Not exactly terribly helpful.
Very interesting. Open in new window to see the details.
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*/
AS ( SELECT 2009 AS year
SELECT yl.year + 1 AS year
FROM yearlist yl
WHERE yl.year + 1 <= YEAR(GETDATE())
ORDER BY year DESC;