USP_TICKET_TEMPLATEINFORMATION

Provides information to ticket templates to facilitate ticket printing

Parameters

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

Definition

Copy



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

    set transaction isolation level read uncommitted;

    select
    EVENTNAME,
    LOCATIONNAME,
    STARTDATETIME as EVENTTIME,
    PRICETYPE as DESCRIPTION,
    PRICE,
    TICKETNUMBER,
    SALESMETHODTYPE,
    DISPLAYTIME as EVENTDISPLAYTIME,
    ORGANIZATIONNAME
    from dbo.UFN_TICKET_TEMPLATEINFORMATION(@ORDERID, @PROGRAMID, @REPRINTJOB, @TICKETPRINTINFOID);

end