2
Answers

Error - An aggregate may not appear in the set list of an UPDATE state

Ramco Ramco

Ramco Ramco

1y
608
1

Hi

  In below code i am getting error

UPDATE [SessionDeliveryParticipant]
SET Attendance = CASE
    WHEN (
        SELECT COUNT(*) 
        FROM [SessionDeliveryParticipant] AS sub 
        WHERE sub.SessionDeliveryCalendarID = SessionDeliveryCalendarID
        AND sub.PresentInSession = 0
    ) = COUNT(*) THEN 1
    ELSE 0
END;

Thanks

Answers (2)