USP_DATALIST_EVENTPROFILEREPORT_HEADER

This datalist returns general header information that is used by the event profile dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Event ID

Definition

Copy



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

                    select 
                        EVENT.NAME as EVENTNAME,
                        EVENT.DESCRIPTION,
                        EVENT.STARTDATE,
                        EVENT.ENDDATE,
                        dbo.UFN_HOURMINUTE_DISPLAYTIME(EVENT.STARTTIME) as STARTTIME,
                        dbo.UFN_HOURMINUTE_DISPLAYTIME(EVENT.ENDTIME) as ENDTIME
                    from 
                        dbo.EVENT
                    where
                        EVENT.ID = @EVENTID;