You can use ROW_NUMBER() in SQL Server 2005. This is similar to 'rownum' in Oracle. A list of dates can then be obtained as follows:

--------------------------------------------------------------

-- Code to return...