USP_REPORT_EVENTATTENDEE_HEADER

                create procedure dbo.USP_REPORT_EVENTATTENDEE_HEADER
                (
                    @EVENTID uniqueidentifier
                )
                as
                begin
                    set nocount on;

                    select
                        [EVENT].NAME as EVENTNAME,
                        [EVENT].STARTDATETIME as EVENTDATE,
                        dbo.UFN_HOURMINUTE_DISPLAYTIME([EVENT].STARTTIME) STARTTIME,
                        dbo.UFN_EVENT_GETAVAILABILITY([EVENT].ID) as AVAILABILITY,
                        [EVENT].CAPACITY
                    from dbo.[EVENT]
                    where ID = @EVENTID

                end