UFN_PROGRAMEVENTLOCATION_GETEVENTCONFLICTLOCATIONS

Retrieves locations that belong to an event conflict.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTCONFLICTID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_PROGRAMEVENTLOCATION_GETEVENTCONFLICTLOCATIONS
        (
            @EVENTCONFLICTID uniqueidentifier
        )
        returns table
        as return
            select PROGRAMEVENTLOCATION.ID,
                EVENTLOCATIONID
            from dbo.PROGRAMEVENTLOCATION
            where EVENTCONFLICTID = @EVENTCONFLICTID;