sql function getRangeMonthList

getRangeMonthList.sql

CREATE FUNCTION getRangeMonthList(@beginDate VARCHAR(50), @endDate VARCHAR(50))
    RETURNS @table TABLE
                   (
                       MonthList VARCHAR(20)
                   )
    AS
    BEGIN
        WITH x AS
                 (
                     SELECT CAST(@beginDate AS DATE) [Month]
                     UNION ALL
                     SELECT DATEADD(M, 1, [Month])
                         FROM x
                         WHERE [Month] < CAST(@endDate AS DATE)
                 )

        INSERT
            INTO @table
        SELECT CONVERT(VARCHAR(7), [Month], 126) AS MonthList
            FROM x
            WHERE CONVERT(VARCHAR(7), [Month], 126) < @endDate
        RETURN
    END
GO