USP_DATALIST_SVGDOCUMENT_TICKET

Parameters

Parameter	Parameter Type	Mode
@ORDERID	uniqueidentifier	IN
@PROGRAMID	uniqueidentifier	IN
@REPRINTJOB	uniqueidentifier	IN
@TICKETPRINTINFOID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SVGDOCUMENT_TICKET
(
    @ORDERID uniqueidentifier = null,
    @PROGRAMID uniqueidentifier = null,
    @REPRINTJOB uniqueidentifier = null,
    @TICKETPRINTINFOID uniqueidentifier = null
)
as
    set nocount on; 

    set transaction isolation level read uncommitted;

    select 
        TICKETNUMBER,
        '*' + cast(TICKETNUMBER as nvarchar(max)) + '*' as BARCODE,
        ORGANIZATIONNAME,        
        PROGRAMNAME,    
        EVENTNAME, 
        SALESMETHODTYPE,
        PRICETYPE,
        PRICE,            
        LOCATIONNAME,       
        STARTDATETIME as EVENTSTARTDATE 
    from dbo.UFN_TICKET_TEMPLATEINFORMATION(@ORDERID, @PROGRAMID, @REPRINTJOB, @TICKETPRINTINFOID);