TR_TRANSLATIONTABLEGRADE_DELETE_DELETENUMERICSTUDENTMARKINGCOLUMNGRADE (Trigger)

                
                CREATE trigger [dbo].[TR_TRANSLATIONTABLEGRADE_DELETE_DELETENUMERICSTUDENTMARKINGCOLUMNGRADE] on [dbo].[TRANSLATIONTABLEGRADE]
                for delete
                as
                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 STUDENTMARKINGCOLUMNGRADE
                from deleted t1
                inner join dbo.COURSEGRADINGMARKINGCOLUMN on t1.TRANSLATIONTABLEID = COURSEGRADINGMARKINGCOLUMN.TRANSLATIONTABLEID
                inner join dbo.STUDENTMARKINGCOLUMNGRADE on STUDENTMARKINGCOLUMNGRADE.NUMERICGRADEVALUE between t1.LOWESTSCORE and t1.HIGHESTSCORE and 
                            COURSEGRADINGMARKINGCOLUMN.ID = STUDENTMARKINGCOLUMNGRADE.COURSEGRADINGMARKINGCOLUMNID and
                            STUDENTMARKINGCOLUMNGRADE.GRADETYPECODE = 2 and 
                            STUDENTMARKINGCOLUMNGRADE.GRADEISBLANK = 0

                --Reset CONTEXT_INFO to previous value 

                if not @CONTEXTCACHE is null 
                  set CONTEXT_INFO @CONTEXTCACHE;