USP_RECORDOPERATION_BBIS_TRANSBATCHUPGRADEINFOCLEAR

CREATE procedure dbo.USP_RECORDOPERATION_BBIS_TRANSBATCHUPGRADEINFOCLEAR (
    @CHANGEAGENTID uniqueidentifier
) as begin
    set nocount on;

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

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    update
        dbo.BBIS_TRANSBATCHUPGRADEINFO
    set
        SHOWDONATIONANDSIGNUPUPGRADEINFO = 0,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE;

    return 0;
end