USP_RESERVATION_TOGGLEORDERBALANCESENT

            create procedure dbo.USP_RESERVATION_TOGGLEORDERBALANCESENT
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as begin
                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                begin try
                    update dbo.[RESERVATION]
                    set
                        [ORDERBALANCESENT] = ~[ORDERBALANCESENT],
                        [CHANGEDBYID] = @CHANGEAGENTID,
                        [DATECHANGED] = @CURRENTDATE
                    where [ID] = @ID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch
                return 0;
            end