UFN_EVENTCONFLICT_GETLOCATIONSINCONFLICT

Get all of the locations that are in conflict within the supplied information.

Return

Return Type
table

Parameters

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

Definition

Copy



            CREATE function dbo.UFN_EVENTCONFLICT_GETLOCATIONSINCONFLICT
            (
                @START datetime,
                @END datetime,
                @LOCATIONS xml,
                @IGNORERECORDID uniqueidentifier = null,
                @IGNORESUBRECORDID uniqueidentifier = null
            )
            returns @CONFLICTS TABLE
                (
                    LOCATIONID uniqueidentifier
                )
            as
            begin 

                insert into @CONFLICTS
                    (LOCATIONID)
                select distinct LOCATIONCONFLICTDETAILS.LOCATIONID
                from dbo.UFN_EVENTCONFLICT_GETLOCATIONCONFLICTDETAILS(@START, @END, @LOCATIONS, @IGNORERECORDID, @IGNORESUBRECORDID, null, 1, 1) as LOCATIONCONFLICTDETAILS

                return;
            end