Display dates between two dates in SQL Server using While Loop

Hi jmprateek,

Please refer below SQL Query.

SQL

CREATE TABLE #temp([EMIDate] DATE)

Declare @StartDate Date = '01-05-2013'
Declare @EndDate Date = '01-11-2013'

WHILE @StartDate <= @EndDate
BEGIN 
	INSERT INTO #temp ([EMIDate]) VALUES (@StartDate)
	SET @StartDate = DATEADD(DAY,1,@StartDate)
END
SELECT CONVERT(VARCHAR(20),[EMIDate],101)[EMIDate] FROM #temp
DROP TABLE #temp

Screenshot