USP_DATALIST_GROUPEDEVENTS
Displays a list of supporting events for a given main event.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MAINEVENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
create procedure dbo.USP_DATALIST_GROUPEDEVENTS
(
@MAINEVENTID uniqueidentifier
)
as
set nocount on;
select
EVENT.ID,
EVENT.NAME,
EVENT.STARTDATE,
EVENT.STARTTIME,
EVENT.ENDDATE,
EVENT.ENDTIME,
coalesce((select count(ID) from dbo.REGISTRANT where EVENTID = EVENT.ID), 0),
EVENT.CAPACITY,
dbo.UFN_EVENTLOCATION_GETNAME(EVENT.EVENTLOCATIONID),
SUPPORTINGEVENTSCOUNT = (select count(ID) from dbo.EVENT as SUPPORTINGEVENT where SUPPORTINGEVENT.MAINEVENTID = EVENT.ID),
case when EVENT.MAINEVENTID is null then cast(1 as bit) else cast(0 as bit) end
from
dbo.EVENT
where
EVENT.MAINEVENTID = @MAINEVENTID or
EVENT.ID = @MAINEVENTID
order by
EVENT.NAME;