MSSQL - Getting all dates between from date and to date.

declare @col nvarchar(max) 

declare @query nvarchar(max)

declare @StartDate as date 

declare @EndDate as date 

set @StartDate = '2014-06-01'

set @EndDate = '2014-06-18'

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL DROP TABLE #TempTable

create TABLE #TempTable 

( 

      Rep_Date date 

) 

 

while @StartDate <= @EndDate 

begin 

 insert into #TempTable (Rep_Date) values(@StartDate) 

 set @StartDate = DATEADD(dd,1,@StartDate) 

end 

  

select * from  #TempTable 

 

drop table #TempTable