You could do something like this

declare @start datetime, @counter int, @end int

set @start = '1/1/2007'

set @end = datediff(dd,@start,getdate())

set @counter = 0

declare @tbl table(

Dt SMALLDATETIME

)

while @counter <= @end

begin

INSERT INTO @tbl (Dt)

Values(CONVERT(VARCHAR,dateadd(dd,-1 * @counter, GETDATE()),101))

set @counter = @counter + 1

end

select *

from @tbl