Создание функции для расчета нарастающих итогов

CREATE FUNCTION get_product_data (@DATE DATE, @product_name VARCHAR(50))
RETURNS @temp_table TABLE (
    chosen_date DATE,
    chosen_product_quantity INT,
    month_to_date INT,
    quarter_to_date INT,
    year_to_date INT
)
AS
BEGIN
    DECLARE @start_of_month DATE, @start_of_quarter DATE, @start_of_year DATE;
    SET @start_of_month = DATEFROMPARTS(YEAR(@DATE), MONTH(@DATE), 1);
    SET @start_of_quarter = DATEADD(QQ, DATEDIFF(QQ, 0, @DATE), 0);
    SET @start_of_year = DATEFROMPARTS(YEAR(@DATE), 1, 1);
 
    INSERT INTO @temp_table (chosen_date, chosen_product_quantity, month_to_date, quarter_to_date, year_to_date)
    SELECT 
        [Дата],
        CASE 
            WHEN @product_name = 'Продукт1' THEN [Продукт1]
            WHEN @product_name = 'Продукт2' THEN [Продукт2]
        END,
        SUM(CASE 
            WHEN @product_name = 'Продукт1' THEN [Продукт1]
            WHEN @product_name = 'Продукт2' THEN [Продукт2]
        END) OVER (PARTITION BY YEAR([Дата]), MONTH([Дата]) ORDER BY [Дата]),
        SUM(CASE 
            WHEN @product_name = 'Продукт1' THEN [Продукт1]
            WHEN @product_name = 'Продукт2' THEN [Продукт2]
        END) OVER (PARTITION BY YEAR([Дата]), DATEPART(QQ, [Дата]) ORDER BY [Дата]),
        SUM(CASE 
            WHEN @product_name = 'Продукт1' THEN [Продукт1]
            WHEN @product_name = 'Продукт2' THEN [Продукт2]
        END) OVER (PARTITION BY YEAR([Дата]) ORDER BY [Дата])
    FROM Продукция
    WHERE [Дата] = @DATE;
 
    RETURN;
END;