UFN_EVENTCONFLICT_GETRESOURCECONFLICTS

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

Return

Return Type
table

Parameters

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

Definition

Copy



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

            insert into @CONFLICTS
                (EVENTID, ITINERARYITEMID, ITINERARYID, RESOURCES)
            select RESOURCECONFLICTDETAILS.EVENTID, RESOURCECONFLICTDETAILS.ITINERARYITEMID, RESOURCECONFLICTDETAILS.ITINERARYID, dbo.UDA_BUILDLIST(RESOURCE.NAME) + ': ' + cast(sum(RESOURCECONFLICTDETAILS.QUANTITYNEEDED) as nvarchar(20))
            from dbo.UFN_EVENTCONFLICT_GETRESOURCECONFLICTDETAILS(@START, @END, @RESOURCES, @IGNORERECORDID, @IGNORESUBRECORDID, null, @INCLUDEEVENTCONFLICTS, @INCLUDEITINERARYITEMCONFLICTS, @INCLUDEITINERARYCONFLICTS, null) as RESOURCECONFLICTDETAILS
                inner join dbo.RESOURCE
                    on RESOURCECONFLICTDETAILS.RESOURCEID = RESOURCE.ID
            group by RESOURCECONFLICTDETAILS.EVENTID, RESOURCECONFLICTDETAILS.ITINERARYITEMID, RESOURCECONFLICTDETAILS.ITINERARYID

            return;
        end