TR_STUDENTCLASSMEETINGGROUP_VALIDATE_ENROLLMENT (Trigger)

                
                    CREATE trigger dbo.TR_STUDENTCLASSMEETINGGROUP_VALIDATE_ENROLLMENT
                        on dbo.STUDENTCLASSMEETINGGROUP
                        after insert, update
                    as
                    begin
                        set nocount on
                        
                        if exists(
                            select 1
                            from dbo.STUDENTCOURSE
                                inner join dbo.STUDENTCLASSMEETINGGROUP on STUDENTCOURSE.ID = STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID
                                inner join inserted on STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID = inserted.CLASSMEETINGGROUPID
                            where STUDENTCLASSMEETINGGROUP.STATUSCODE = 0
                            group by STUDENTCOURSE.STUDENTID, STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID
                            having COUNT(distinct STUDENTCLASSMEETINGGROUP.ID) > 1)
                        raiserror('BBERR_STUDENTCLASSMEETINGGROUP_VALIDATE_ENROLLMENT', 13, 1);
                    end