UFN_EVENTCONFLICT_GETLOCATIONCONFLICTS

Get all of the events that are in conflict with the given event conflict by location.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@START	datetime	IN
@END	datetime	IN
@LOCATIONS	xml	IN
@IGNORERECORDID	uniqueidentifier	IN
@IGNORESUBRECORDID	uniqueidentifier	IN
@INCLUDEEVENTCONFLICTS	bit	IN
@INCLUDEITINERARYITEMCONFLICTS	bit	IN

Definition

Copy



            CREATE function dbo.UFN_EVENTCONFLICT_GETLOCATIONCONFLICTS
            (
                @START datetime,
                @END datetime,
                @LOCATIONS xml,
                @IGNORERECORDID uniqueidentifier = null,
                @IGNORESUBRECORDID uniqueidentifier = null,
                @INCLUDEEVENTCONFLICTS bit = 1,
                @INCLUDEITINERARYITEMCONFLICTS bit = 1
            )
            returns @CONFLICTS TABLE
                (
                    EVENTID uniqueidentifier,
                    ITINERARYITEMID uniqueidentifier,
                    LOCATIONS nvarchar(500)
                )
            as
            begin 

                insert into @CONFLICTS
                    (EVENTID, ITINERARYITEMID, LOCATIONS)
                select LOCATIONCONFLICTDETAILS.EVENTID, LOCATIONCONFLICTDETAILS.ITINERARYITEMID, dbo.UDA_BUILDLIST(EVENTLOCATION.NAME)
                from dbo.UFN_EVENTCONFLICT_GETLOCATIONCONFLICTDETAILS(@START, @END, @LOCATIONS, @IGNORERECORDID, @IGNORESUBRECORDID, null, @INCLUDEEVENTCONFLICTS, @INCLUDEITINERARYITEMCONFLICTS) as LOCATIONCONFLICTDETAILS
                    inner join dbo.EVENTLOCATION
                        on LOCATIONCONFLICTDETAILS.LOCATIONID = EVENTLOCATION.ID
                group by LOCATIONCONFLICTDETAILS.EVENTID, LOCATIONCONFLICTDETAILS.ITINERARYITEMID

                return;
            end