USP_SIMPLEDATALIST_EVENTGROUP
A simple data list of events in an event group.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MAINEVENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_EVENTGROUP
(
@MAINEVENTID uniqueidentifier = null
)
as
set nocount on;
select
ID as VALUE,
NAME as LABEL
from
dbo.EVENT
where
EVENT.ID = @MAINEVENTID OR EVENT.MAINEVENTID = @MAINEVENTID
order by
NAME;