Dates between Startdate and Enddate

-- these would be your input parameters
DECLARE
        @empno int,
        @start_date datetime,
        @end_date datetime,
        @project nvarchar(50)
-- set them to some values for testing
SELECT
        @empno = 1,
        @start_date = '10/01/2009',
        @end_date = '10/04/2009',
        @project = 'abc'

-- this is used by the loop
DECLARE @working_date datetime
SET @working_date = @start_date
WHILE @working_date < @end_dateBEGIN
        INSERT
                MyTable
                (
                empno,
                [date],
                project
                )
        SELECT
                @empno,
                @working_date,
                @project

        SET @working_date = DATEADD(d, 1, @working_date)
EN