TR_COURSEGRADINGMARKINGCOLUMN_UPDATE_CHANGESTUDENTGRADE_TRANSLATIONTABLEGRADEID (Trigger)

                
                    CREATE trigger TR_COURSEGRADINGMARKINGCOLUMN_UPDATE_CHANGESTUDENTGRADE_TRANSLATIONTABLEGRADEID 
                    on dbo.COURSEGRADINGMARKINGCOLUMN                    
                    after update
                    not for replication
                    as begin
                        if update(TRANSLATIONTABLEID)
                        begin
                            update dbo.STUDENTMARKINGCOLUMNGRADE 
                            set TRANSLATIONTABLEGRADEID = SELECTED.ID,
                                CHANGEDBYID = I.CHANGEDBYID,
                                DATECHANGED = I.DATECHANGED
                            from inserted I
                            inner join dbo.STUDENTMARKINGCOLUMNGRADE on I.ID = STUDENTMARKINGCOLUMNGRADE.COURSEGRADINGMARKINGCOLUMNID
                            inner join dbo.TRANSLATIONTABLEGRADE EXISTING on STUDENTMARKINGCOLUMNGRADE.TRANSLATIONTABLEGRADEID = EXISTING.ID                            
                            inner join dbo.TRANSLATIONTABLEGRADE SELECTED on I.TRANSLATIONTABLEID = SELECTED.TRANSLATIONTABLEID and 
                                EXISTING.GRADE = SELECTED.GRADE
                            where STUDENTMARKINGCOLUMNGRADE.TRANSLATIONTABLEGRADEID is not null and
                                STUDENTMARKINGCOLUMNGRADE.GRADETYPECODE = 1
                        end
                    end