UFN_TICKETPRINTINFO_GETUNPRINTABLE_BYREPRINTJOB

Retrieves tickets that failed to print.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REPRINTJOB	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_TICKETPRINTINFO_GETUNPRINTABLE_BYREPRINTJOB (
                @REPRINTJOB uniqueidentifier
            )
            returns table
            as return
                select 
                    TICKETPRINTINFO.ID,
                    TICKETPRINTINFO.TICKETID
                from dbo.[TICKETPRINTINFO]
                where
                    [TICKETPRINTINFO].[REPRINTJOB] = @REPRINTJOB and
                    [TICKETPRINTINFO].[WORKSTATIONID] is null