Ciclare con data inizio e data fine

>Un aiutinooooo please!

USE
tempdb;

GO

CREATE
TABLE tempDates

(
Id smallint IDENTITY(1,1) NOT NULL PRIMARY KEY
, DataDa smalldatetime
, DataA smalldatetime
)

DECLARE @DataDa smalldatetime
               , @DataA smalldatetime
               , @OraDa smalldatetime
               , @OraA smalldatetime

SET @DataDa = '20080101'
SET @DataA = '20081231'

WHILE @DataDa <= @DataA
BEGIN
     SET @OraDa = @DataDa + ' 08:00'
     SET @OraA = @DataDa + ' 19:00'

     INSERT INTO tempDates (DataDa, DataA) VALUES (@OraDa, @OraA)
     SET @DataDa = DATEADD(day, 1, @DataDa)
END

SELECT * FROM tempDates

-- pulizia

DROP TABLE tempDates
GO