USP_REMINDERHISTORY_DELETEHISTORY

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

    update dbo.PLEDGEREMINDERSENT
    set
        MKTSEGMENTATIONACTIVATEPROCESSSTATUSID = null,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
    where
        MKTSEGMENTATIONACTIVATEPROCESSSTATUSID = @ID

    exec USP_BUSINESSPROCESSSTATUS_DELETE @ID, @CHANGEAGENTID;
    return 0;
end