USP_REPORT_SCHEDULEDTICKETDETAIL_HEADER

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

    select
        [EVENT].NAME as EVENTNAME,
        [EVENT].STARTDATETIME as EVENTDATE,
        dbo.UFN_HOURMINUTE_DISPLAYTIME([EVENT].STARTTIME) STARTTIME,
        AVAILABILITY,
        [EVENT].CAPACITY,
        INORDER as RESERVED
    from 
        dbo.[EVENT]
    inner join 
        dbo.V_PROGRAMEVENT_TICKETCOUNTS on [EVENT].ID = V_PROGRAMEVENT_TICKETCOUNTS.ID
    where 
        [EVENT].ID = @EVENTID

end