Database

Msg 217, Level 16, State 1, Procedure rptClassInformation_sel, Line 26. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

WITH CTE AS
    (
    SELECT FILTER.GroupKey,
        FILTER.ClassScheduleId,
        SUM(SlotCount) AS SlotCount
    FROM    #SlotInformation INFO
        INNER JOIN #Base FILTER
            ON FILTER.ClassScheduleId  = INFO.ClassScheduleId
            AND (
                    @Level = 'Class'
                OR  FILTER.UseInAggs = 1
                )
    WHERE   SlotPlanTypeId IN (@SLOTPLAN_ECEAP, @SLOTPLAN_ECEAPSPED)
    GROUP BY
        FILTER.GroupKey,
        FILTER.ClassScheduleId
    )

INSERT  INTO #Results
    (GroupKey, Identifier, Name, Value)
SELECT  WEEK.GroupKey,
    'NIEER' AS Identifier,
    'Number of ECEAP slots in ECEAP classes meeting 8 or more hours per day' AS Name,
    SUM(CASE WHEN WEEK.AverageHoursPerDay >= 8 THEN CTE.SlotCount ELSE 0 END) AS Value
FROM    #WeeklyOverview WEEK
    INNER JOIN CTE
        ON CTE.GroupKey = WEEK.GroupKey
        AND CTE.ClassScheduleId = WEEK.ClassScheduleId
GROUP BY
    WEEK.GroupKey

UNION ALL

SELECT  WEEK.GroupKey,
    'NIEER' AS Identifier,
    'Number of ECEAP slots in ECEAP classes meeting at least 4 hours but fewer than 8 hours per day' AS Name,
    SUM(CASE WHEN WEEK.AverageHoursPerDay >= 4 AND WEEK.AverageHoursPerDay < 8 THEN CTE.SlotCount ELSE 0 END) AS Value
FROM    #WeeklyOverview WEEK
    INNER JOIN CTE
        ON CTE.GroupKey = WEEK.GroupKey
        AND CTE.ClassScheduleId = WEEK.ClassScheduleId
GROUP BY
    WEEK.GroupKey

UNION ALL

SELECT  WEEK.GroupKey,
    'NIEER' AS Identifier,
    'Number of ECEAP slots in ECEAP classes meeting fewer than 4 hours per day' AS Name,
    SUM(CASE WHEN WEEK.AverageHoursPerDay < 4 THEN CTE.SlotCount ELSE 0 END) AS Value
FROM    #WeeklyOverview WEEK
    INNER JOIN CTE
        ON CTE.GroupKey = WEEK.GroupKey
        AND CTE.ClassScheduleId = WEEK.ClassScheduleId
GROUP BY
    WEEK.GroupKey;