UFN_ORDER_GETTICKETS

CREATE function dbo.UFN_ORDER_GETTICKETS(@ORDERID uniqueidentifier)
returns table
as return
    select
        TICKET.ID,
        cast (  case
                    when (TICKET.TICKETNUMBER > 0) then 0
                    when not exists(select DOCUMENT.ID 
                                from dbo.DOCUMENT inner join dbo.PROGRAMDOCUMENT on
                                    DOCUMENT.ID = PROGRAMDOCUMENT.DOCUMENTID
                                where
                                    DOCUMENT.ISACTIVE = 1 and
                                    (
                                        (SOIT.EVENTID is not null and PROGRAMDOCUMENT.PROGRAMID = EVENT.PROGRAMID) or
                                        (SOIT.EVENTID is null and PROGRAMDOCUMENT.PROGRAMID = SOIT.PROGRAMID)
                                    )) then 0
                    else 1
                end as BIT) as [PRINT],
        SOI.DESCRIPTION as NAME,
        EVENT.STARTDATE as EVENTDATE,
        EVENT.STARTTIME as EVENTTIME,
        (select count(*) from dbo.TICKETPRINTINFO where TICKETID = TICKET.ID) as PRINTCOUNT,
        TICKET.TICKETNUMBER as BARCODE
    from dbo.TICKET
        inner join dbo.SALESORDERITEMTICKET SOIT on TICKET.SALESORDERITEMTICKETID = SOIT.ID
        inner join dbo.SALESORDERITEM SOI on SOI.ID = SOIT.ID
        left join dbo.EVENT on SOIT.EVENTID = EVENT.ID
    where
        SOI.SALESORDERID = @ORDERID