UFN_EVENT_GETLOCATIONS

Get the locations attached to a given event

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_EVENT_GETLOCATIONS
      (
          @EVENTID uniqueidentifier
      ) returns table
      as
          return
          select
              PROGRAMEVENTLOCATION.ID,
              PROGRAMEVENTLOCATION.EVENTLOCATIONID,
              EVENTLOCATION.CAPACITY
          from
              dbo.PROGRAMEVENTLOCATION
              inner join EVENTLOCATION on PROGRAMEVENTLOCATION.EVENTLOCATIONID = EVENTLOCATION.ID
          where
              EVENTID = @EVENTID