With the introduction of CTEs is SQL 2005 it made it a lot easier to create a record for every date in a range.

WITH Dates AS (

SELECT

[Date] = CONVERT(DATETIME,'01/01/2010')

UNION...