Get a table of Month Ends between two dates without using a LOOP

gistfile1.txt

	SET @StartDate = CONVERT(DATETIME, CONVERT(VARCHAR, MONTH(@StartDate)) + '/1/' + CONVERT(VARCHAR, YEAR(@StartDate)));

	-- get a table of all of the month ends between @startDate and @endDate
	CREATE TABLE #MonthEnds (
		MonthEnd DATETIME
	);
	INSERT INTO #MonthEnds (MonthEnd)
	SELECT TOP (DATEDIFF(MONTH, @StartDate, @EndDate)+1) 
		DATEADD(
			DAY,
			-1,
			DATEADD(
				MONTH, 
				ROW_NUMBER() OVER(ORDER BY object_id),
				@StartDate
			)
		)
	FROM sys.all_objects -- used primarily to generate a Numbers table