USP_STUDENTMARKINGCOLUMN_CLEARBLANKGRADES

create procedure dbo.USP_STUDENTMARKINGCOLUMN_CLEARBLANKGRADES
(
    @STUDENTCOURSEID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
begin
    declare @contextCache varbinary(128);
    declare @e int;

    -- cache current context information 

    set @contextCache = CONTEXT_INFO();

    -- set CONTEXT_INFO to @CHANGEAGENTID 

    if not @CHANGEAGENTID is null
        set CONTEXT_INFO @CHANGEAGENTID;

    delete from dbo.STUDENTMARKINGCOLUMNGRADE
    from dbo.STUDENTMARKINGCOLUMNGRADE
        inner join dbo.STUDENTCLASSMEETINGGROUP on STUDENTMARKINGCOLUMNGRADE.STUDENTCLASSMEETINGGROUPID = STUDENTCLASSMEETINGGROUP.ID
    where STUDENTMARKINGCOLUMNGRADE.GRADEISBLANK = 1
        and STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID = @STUDENTCOURSEID

    select @e=@@error;

    -- reset CONTEXT_INFO to previous value 

    if not @contextCache is null
        set CONTEXT_INFO @contextCache;

    if @e <> 0
        return 2;
end