TR_STUDENTPROGRESSION_DELETE_CHECKFORCLASSES (Trigger)

                
                    CREATE trigger [dbo].[TR_STUDENTPROGRESSION_DELETE_CHECKFORCLASSES] on [dbo].[STUDENTPROGRESSION] after delete not for replication
                        as begin
                            if exists (
                                select 1
                                from deleted
                                    inner join dbo.EDUCATIONALHISTORY on deleted.ENROLLMENTID = EDUCATIONALHISTORY.ID
                                    inner join dbo.CLASSMEETINGGROUP on
                                        deleted.STARTDATE <= CLASSMEETINGGROUP.STARTDATE and
                                        deleted.ENDDATE >= CLASSMEETINGGROUP.ENDDATE
                                    inner join dbo.STUDENTCLASSMEETINGGROUP on CLASSMEETINGGROUP.ID = STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID
                                    inner join dbo.STUDENTCOURSE on
                                        STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID = STUDENTCOURSE.ID and
                                        EDUCATIONALHISTORY.CONSTITUENTID = STUDENTCOURSE.STUDENTID
                                )
                            begin
                                raiserror('BBERR_STUDENTPROGRESSION_DELETE_CHECKFORCLASSES', 13, 1);
                            end
                        end