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;

<h2>Id | Class</h2>

1  | 7th Class
2  | 8th Class
4  | 10th Class

Marks Table has values as 

StudentId | ClassId | Marks |
1         | 1       | 35
2         | 1       | 90
3         | 2       | 75
4         | 2       | 30
5         | 4       | 99
6         | 4       | 25
7         | 4       | 36
8         | 4       | 70
9         | 4       | 65
10        | 4       | 55

Now the resulting table should look as below

Class       | Failed | Passed  |Distinction
7 th Class    count     count     count