select * from table where dt between @startdate and @enddate

declare @StartDate date = '20120101';
declare @EndDate date = '20120112';

WITH x (dt)
     AS (SELECT @StartDate
         UNION ALL
         SELECT dateadd(dd,1,dt)
         FROM   x
         WHERE  dt<@EndDate)
SELECT *
FROM   x