TR_STUDENTCLASSMEETINGGROUP_STUDENTCOURSE_DELETE (Trigger)

                
                    CREATE trigger dbo.TR_STUDENTCLASSMEETINGGROUP_STUDENTCOURSE_DELETE
                        on dbo.STUDENTCLASSMEETINGGROUP
                        after delete
                    as
                    begin
                        set nocount on
                        
                        declare @ChangeAgentID uniqueidentifier
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENTFROMCONTEXT @ChangeAgentID output

                        --Cache current context information 

                        declare @CONTEXTCACHE varbinary(128)
                        set @CONTEXTCACHE = CONTEXT_INFO()

                        --Set CONTEXT_INFO to @CHANGEAGENTID 

                        if @CHANGEAGENTID is not null 
                          set CONTEXT_INFO @CHANGEAGENTID

                        delete from dbo.STUDENTCOURSE
                        from dbo.STUDENTCOURSE
                            inner join deleted on STUDENTCOURSE.ID = deleted.STUDENTCOURSEID
                            left join dbo.STUDENTCLASSMEETINGGROUP on STUDENTCOURSE.ID = STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID
                            left join dbo.STUDENTCOURSEREQUEST on STUDENTCOURSE.ID = STUDENTCOURSEREQUEST.ID
                        where STUDENTCOURSEREQUEST.ID is null
                            and STUDENTCLASSMEETINGGROUP.ID is null

                        --Reset CONTEXT_INFO to previous value 

                        if not @CONTEXTCACHE is null 
                          set CONTEXT_INFO @CONTEXTCACHE
                    end