SQL - select first/last days of months in a interval

months.sql

DECLARE @StartDate DATETIME, @EndDate DATETIME; -- don't forget to set them!
-- for example:
-- SELECT @StartDate = min(OrderDate), @EndDate = max(OrderDate) from Orders;

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

;WITH months ( [date] )
AS
(
    SELECT @StartDate
    UNION ALL
    SELECT DATEADD(MONTH, 1, [date])
    FROM months
    WHERE DATEADD(MONTH, 1, [date]) <= @EndDate
)
SELECT DATENAME(MONTH,[date]) + ' ' + DATENAME(YEAR, [date]) as [date_text]
	, DATEADD(MONTH, DATEDIFF(MONTH, 0, [date]), 0) as [start_date]
	, DATEADD(SECOND, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, [date]) + 1, 0) ) as [end_date]
INTO #dates
FROM months;