Creates a list of dates between two dates

cte.sql

declare
	 @dt_Start datetime = '2018-01-01'
	,@dt_End   datetime = '2018-12-31'

;WITH dts AS (
	  SELECT
		sqldatetime = @dt_Start
	  UNION ALL
	  SELECT
		DATEADD(DAY, 1, sqldatetime)
	  FROM
		dts
	  WHERE
		DATEADD(DAY, 1, sqldatetime) <= @dt_End
	)
	select
		*
	from
		dts
		OPTION (MAXRECURSION 1440);

loop.sql

declare
	 @dt_Start datetime = '2018-01-01'
	,@dt_End   datetime = '2018-12-31'

	create table #dt (
		dt datetime
	);

	declare @date datetime

	set @date = @dt_Start
			
	WHILE @DATE <= @dt_End
	BEGIN
		insert into #dt
		select
			@date

		SET @DATE = DATEADD(DD, 1, @DATE)
	END


	select * from #dt