USP_PROGRAMEVENTPRICE_INSERTPRICES

        CREATE procedure dbo.USP_PROGRAMEVENTPRICE_INSERTPRICES
        (
            @EVENTS xml,
            @CHANGEAGENTID uniqueidentifier,
            @CURRENTDATE datetime
        )
        as
        begin


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

            if @CURRENTDATE is null
                set @CURRENTDATE = getdate()

            begin try
                declare @idoc int;
                exec sp_xml_preparedocument @idoc OUTPUT, @EVENTS
                insert into dbo.PROGRAMEVENTPRICE
                (
                    ID,
                    EVENTID,
                    PRICETYPECODEID,
                    FACEPRICE,
                    SEQUENCE,
                    ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
                )
                select
                    newid(),
                    EVENTID,
                    PP.PRICETYPECODEID,
                    PP.FACEPRICE,
                    PP.SEQUENCE,
                    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
                    from openxml (@idoc,'/EVENTS/ITEM', 2)
                with
                    (EVENTID uniqueidentifier,
                    PROGRAMID uniqueidentifier,
                    ISCONFLICT bit) P
                inner join     PROGRAMPRICE PP on PP.PROGRAMID = P.PROGRAMID
                where ISCONFLICT = 0

                exec sp_xml_removedocument @idoc


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

        end