USP_CMSEVENTOPTION_ADDEDIT

            CREATE procedure dbo.USP_CMSEVENTOPTION_ADDEDIT
            (
                @ID uniqueidentifier = null,
                @OPTIONDATA xml
            )
            as

            set nocount on;

            begin try

                declare @CHANGEAGENTID uniqueidentifier
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                if exists(select 1 from dbo.CMSEVENTOPTION where ID = @ID)
                    update dbo.CMSEVENTOPTION set OPTIONDATA = @OPTIONDATA where ID = @ID
                else
                    insert into dbo.CMSEVENTOPTION(ID, OPTIONDATA, ADDEDBYID, CHANGEDBYID) 
                    values (@ID, @OPTIONDATA, @CHANGEAGENTID, @CHANGEAGENTID)
            end try

            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

            return 0