declare @DateFrom DateTime = CONVERT(DATETIME, '01/01/2014', 103)

declare @DateTo DateTime = CONVERT(DATETIME, '01/03/2014', 103)

;WITH CTE(dt)

AS

(

Select @DateFrom

Union All

...