USP_SIMPLEDATALIST_PROGRAMEVENTLOCATIONSINUSE

List of all locations in use by events optionally filtered by program

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN	Program

Definition

Copy



create procedure dbo.USP_SIMPLEDATALIST_PROGRAMEVENTLOCATIONSINUSE
(
    @PROGRAMID uniqueidentifier = null
)
as
    set nocount on;

    select
        distinct PROGRAMEVENTLOCATION.EVENTLOCATIONID as VALUE,
        dbo.UFN_EVENTLOCATION_GETNAME(PROGRAMEVENTLOCATION.EVENTLOCATIONID) as LABEL
    from
        dbo.PROGRAMEVENTLOCATION
        inner join dbo.EVENT on EVENT.ID = PROGRAMEVENTLOCATION.EVENTID
    where
        (@PROGRAMID is null or @PROGRAMID = EVENT.PROGRAMID) and
        not (PROGRAMEVENTLOCATION.EVENTLOCATIONID is null)