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