USP_REMINDERHISTORY_CLEARLETTERHISTORY

create procedure dbo.USP_REMINDERHISTORY_CLEARLETTERHISTORY
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    declare @contextCache varbinary(128);

    if @CHANGEAGENTID is null
        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    set @contextCache = CONTEXT_INFO();
    set CONTEXT_INFO @CHANGEAGENTID

    delete from dbo.PLEDGEREMINDERSENT where MKTSEGMENTATIONACTIVATEPROCESSSTATUSID = @ID;

    if not @contextCache is null
        set CONTEXT_INFO @contextCache

    update dbo.BUSINESSPROCESSSTATUS 
    set 
        STATUSCODE = 3,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
    where ID = @ID;

    return 0;    
end