UFN_EVENTCONFLICT_GETSEQUENCEDLOCATIONS

Get the locations attached to a given event conflict

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTCONFLICTID	uniqueidentifier	IN

Definition

Copy



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