USP_EVENT_MERCHANTACCOUNT_EDIT

CREATE procedure dbo.USP_EVENT_MERCHANTACCOUNT_EDIT
(
  @EVENTID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @MERCHANTACCOUNTID uniqueidentifier = null,
  @ISZIPMATCHINGON bit = null
)
as

    set nocount on;

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

    begin try

        -- handle updating the data

        update dbo.EVENTEXTENSION 
    set
        MERCHANTACCOUNTID = @MERCHANTACCOUNTID,
    ISZIPMATCHINGON = isnull(@ISZIPMATCHINGON, ISZIPMATCHINGON),

        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()

        from dbo.EVENTEXTENSION (NOLOCK)
        where EVENTID = @EVENTID

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;