UFN_EVENT_GETMULTICOMPONENTSCHEDULES

Gets the schedules for a main event and (any) related sub-events

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_EVENT_GETMULTICOMPONENTSCHEDULES
(
    @EVENTID uniqueidentifier
)
returns table
as
return
(
    select
        EVENT.ID,
        EVENT.NAME,
        EVENT.STARTDATE,
        EVENT.STARTTIME,
        EVENT.ENDDATE,
        EVENT.ENDTIME
    from
        dbo.EVENT
    where
        EVENT.ID = @EVENTID
        or EVENT.MAINEVENTID = @EVENTID
)