USP_PROGRAMLOCATIONS_ADDXML

Adds the locations collection to the program location table.

Parameters

Parameter	Parameter Type	Mode
@PROGRAMID	uniqueidentifier	IN
@XML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_PROGRAMLOCATIONS_ADDXML
            (
                @PROGRAMID uniqueidentifier,
                @XML xml,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )

            as    

            set nocount on;

            if @CHANGEAGENTID is null
                exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

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

            --- build a temporary table containing the values from the XML

            declare @TempTbl table (
                [EVENTLOCATIONID] uniqueidentifier
            )

            insert into @TempTbl select 
                [EVENTLOCATIONID]
                from dbo.UFN_PROGRAM_ADDLOCATIONS_FROMITEMLISTXML(@XML)


            -- insert new items

            insert into dbo.PROGRAMLOCATION
                (PROGRAMID, 
                EVENTLOCATIONID,
                ID,
                ISDEFAULT,                
                ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED)
            select @PROGRAMID, 
                [EVENTLOCATIONID],
                newid(),
                1, 
                @CHANGEAGENTID, 
                @CHANGEAGENTID, 
                @CHANGEDATE, 
                @CHANGEDATE
            from @TempTbl as [temp];