USP_DATALIST_PROGRAMEVENTLOCATION

List all locations for a given event

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PROGRAMEVENTLOCATION
                (
                    @EVENTID uniqueidentifier
                )
                as
                set nocount on;

                    select
                        EVENTLOCATIONID,
                        dbo.UFN_EVENTLOCATION_GETNAME(EVENTLOCATIONID) as LOCATION
                    from
                        dbo.PROGRAMEVENTLOCATION
                    where
                        EVENTID = @EVENTID