USP_PROGRAMEVENTLOCATION_INSERT

This inserts the locations for an event.

Parameters

Parameter	Parameter Type	Mode
@EVENTID	uniqueidentifier	IN
@EVENTCONFLICTID	uniqueidentifier	IN
@EVENTLOCATIONID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEQUENCE	int	IN

Definition

Copy



            CREATE procedure dbo.USP_PROGRAMEVENTLOCATION_INSERT
            (
                @EVENTID uniqueidentifier,
                @EVENTCONFLICTID uniqueidentifier,
                @EVENTLOCATIONID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier=null,
                @SEQUENCE int = 0
            )
            as 
                set nocount on;
                declare @ID uniqueidentifier;    
                set @ID = newid();

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()


                insert into dbo.PROGRAMEVENTLOCATION
                (
                ID,
                EVENTID,
                EVENTCONFLICTID,
                EVENTLOCATIONID,
                SEQUENCE,
                ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED
                )

                values 

                (
                @ID,
                @EVENTID,
                @EVENTCONFLICTID,
                @EVENTLOCATIONID,
                @SEQUENCE,
                @CHANGEAGENTID, 
                @CHANGEAGENTID, 
                @CURRENTDATE, 
                @CURRENTDATE
                );