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