Insert all dates between start and end date into table in SQL Server

First you need to pass the date in Proper Format so you can use the datetime value to compare and add it to the table.

Refer the below test query for your reference and implement it in your code as per your logic.

SQL

CREATE TABLE #Dates(Dates Datetime)

DECLARE @Start DATETIME
DECLARE @End DATETIME

SET @Start = '11/01/2017' -- IN MM/DD/YYYY format
SET @End = '11/30/2017' -- IN MM/DD/YYYY format

DECLARE @Counter INT, @TotalCount INT
SET @Counter = 0 
SET @TotalCount = DateDiff(DD,@Start,@End)
 

WHILE (@Counter <=@TotalCount)
BEGIN
  DECLARE @DateValue DATETIME
  SET  @DateValue= DATEADD(DD,@Counter,@Start)
 
    INSERT INTO #Dates(Dates)
	VALUES(@DateValue)

    SET @Counter = @Counter + 1
END


SELECT * FROM #Dates

Output