USP_RECORDOPERATION_RECURRINGGIFTSTATUSREASONCODETOGGLEACTIVE

    create procedure dbo.USP_RECORDOPERATION_RECURRINGGIFTSTATUSREASONCODETOGGLEACTIVE
    (
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier
    )
    as begin
            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            begin try
                update dbo.RECURRINGGIFTSTATUSREASONCODE set
                    ACTIVE = ~ ACTIVE,
                    DATECHANGED = @CURRENTDATE,
                    CHANGEDBYID = @CHANGEAGENTID
                where ID = @ID
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

        end