UFN_TICKET_GETPRINTHISTORY

CREATE function dbo.UFN_TICKET_GETPRINTHISTORY(@TICKETID uniqueidentifier)
returns table
as return
    select TPI.ID,
           TPI.PRINTDATEWITHTIMEOFFSET DATEADDED,
           convert(nvarchar, cast(TPI.PRINTDATEWITHTIMEOFFSET as time), 100) PRINTEDTIME,
           coalesce([APPUSER].[DISPLAYNAME],[APPUSER].[USERNAME]) as PRINTEDBY,
           WORKSTATION.NAME as WORKSTATION,
           TPI.SEQUENCEID as BARCODE,
           TPRC.DESCRIPTION as REPRINTREASON
    from dbo.TICKETPRINTINFO TPI
        inner join dbo.WORKSTATION on WORKSTATION.ID = TPI.WORKSTATIONID
        inner join dbo.APPUSER on APPUSER.ID = TPI.APPUSERID
        left join dbo.TICKETREPRINTREASONCODE TPRC on TPRC.ID = TPI.TICKETREPRINTREASONCODEID
    where TICKETID = @TICKETID