USP_DATALIST_TICKETPRINTINFO

create procedure dbo.USP_DATALIST_TICKETPRINTINFO
(
    @TICKETPRINTINFOID uniqueidentifier
)
as
    set nocount on;

    select 
        TICKETPRINTINFO.ID,
        PROGRAM.ID PROGRAMID,
        PROGRAM.NAME PROGRAMNAME,
        EVENT.ID EVENTID,
        EVENT.NAME EVENTNAME,
        TICKETPRINTINFO.SEQUENCEID TICKETNUMBER,
        APPUSER.ID APPUSERID,
        APPUSER.USERNAME,
        DOCUMENT.REPORTCATALOGID
    from
        dbo.TICKETPRINTINFO
    inner join
        dbo.TICKET on TICKETPRINTINFO.TICKETID = TICKET.ID
    left join 
        dbo.PROGRAM on TICKET.PROGRAMID = PROGRAM.ID
    left join
        dbo.EVENT on EVENT.ID = TICKET.EVENTID
    left join 
        dbo.APPUSER on TICKETPRINTINFO.APPUSERID = APPUSER.ID
    left join
        dbo.PROGRAMDOCUMENT on PROGRAMDOCUMENT.PROGRAMID = PROGRAM.ID
    left join 
        dbo.DOCUMENT on DOCUMENT.ID = PROGRAMDOCUMENT.DOCUMENTID
    where
        TICKETPRINTINFO.ID = @TICKETPRINTINFOID