USP_REPORT_DEFAULTTICKETTEMPLATE

create procedure dbo.USP_REPORT_DEFAULTTICKETTEMPLATE
(
    @ORDERID uniqueidentifier,
    @PROGRAMID uniqueidentifier
)
as
begin
    select
        case
            when TICKET.EVENTID is not null then EVENT.NAME
            when TICKET.PROGRAMID is not null then DAILY.NAME
        end as EVENTNAME,
        case
            when TICKET.EVENTID is not null then EL.NAME
            when TICKET.PROGRAMID is not null then DAILYEL.NAME
        end as LOCATIONNAME,
        case
            when TICKET.EVENTID is not null then dbo.UFN_DATE_ADDHOURMINUTE(EVENT.STARTDATE, EVENT.STARTTIME) 
            when TICKET.PROGRAMID is not null then null
        end as EVENTTIME,
        PRICETYPECODE.DESCRIPTION,
        TICKET.PRICE,
        TICKET.TICKETNUMBER,
        SO.SALESMETHODTYPE
    from
        dbo.TICKET
        left join dbo.EVENT on TICKET.EVENTID = EVENT.ID
        left join dbo.PROGRAMEVENTLOCATION PEL on PEL.EVENTID = EVENT.ID
        left join dbo.EVENTLOCATION EL on PEL.EVENTLOCATIONID = EL.ID
        left join dbo.PROGRAM SCHEDULED on EVENT.PROGRAMID = SCHEDULED.ID
        inner join dbo.PRICETYPECODE on TICKET.PRICETYPECODEID = PRICETYPECODE.ID
        inner join dbo.SALESORDERITEMTICKET SOIT on TICKET.SALESORDERITEMTICKETID = SOIT.ID
        inner join dbo.SALESORDERITEM SOI on SOIT.ID = SOI.ID
        inner join dbo.SALESORDER SO on SOI.SALESORDERID = SO.ID
        left join dbo.PROGRAM DAILY on TICKET.PROGRAMID = DAILY.ID
        left join dbo.PROGRAMLOCATION PL on PL.PROGRAMID = DAILY.ID
        left join dbo.EVENTLOCATION DAILYEL on PL.EVENTLOCATIONID = DAILYEL.ID
    where
        SO.ID = @ORDERID and
        (
            SCHEDULED.ID = @PROGRAMID or
            DAILY.ID = @PROGRAMID
        )
    order by
        DESCRIPTION
end