UFN_EVENTCONFLICT_GETLOCATIONS

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_GETLOCATIONS
      (
          @EVENTCONFLICTID uniqueidentifier
      ) returns table
      as
          return
          select
              ID,
              EVENTLOCATIONID as LOCATIONID
          from
              dbo.PROGRAMEVENTLOCATION
          where
              EVENTCONFLICTID = @EVENTCONFLICTID