• Replies 2 replies
  • Subscribers 414 subscribers
  • Views 47 views
  • Users 0 members are here
Related

Orders under batch print

Harpreet Gangyan
$organization

HI,

Is there a way to find out orders printed under certain batch print?

Thanks

Harpreet

Parents
  • Former Member
    Former Member $organization

    I use access for this sort of thing.  Here's the SQL statement:
    SELECT dbo_T_ORDER_SEAT_HIST.customer_no, dbo_T_ORDER_SEAT_HIST.order_no, dbo_T_BATCH.batch_no
    FROM dbo_T_ORDER_SEAT_HIST INNER JOIN dbo_T_BATCH ON dbo_T_ORDER_SEAT_HIST.batch_no = dbo_T_BATCH.batch_no
    WHERE (((dbo_T_ORDER_SEAT_HIST.event_code)=2) AND ((dbo_T_ORDER_SEAT_HIST.event_date)>=#6/9/2009#))
    GROUP BY dbo_T_ORDER_SEAT_HIST.customer_no, dbo_T_ORDER_SEAT_HIST.order_no, dbo_T_BATCH.batch_no
    HAVING (((dbo_T_BATCH.batch_no)=83881))
    ORDER BY dbo_T_ORDER_SEAT_HIST.customer_no;

Reply
  • Former Member
    Former Member $organization

    I use access for this sort of thing.  Here's the SQL statement:
    SELECT dbo_T_ORDER_SEAT_HIST.customer_no, dbo_T_ORDER_SEAT_HIST.order_no, dbo_T_BATCH.batch_no
    FROM dbo_T_ORDER_SEAT_HIST INNER JOIN dbo_T_BATCH ON dbo_T_ORDER_SEAT_HIST.batch_no = dbo_T_BATCH.batch_no
    WHERE (((dbo_T_ORDER_SEAT_HIST.event_code)=2) AND ((dbo_T_ORDER_SEAT_HIST.event_date)>=#6/9/2009#))
    GROUP BY dbo_T_ORDER_SEAT_HIST.customer_no, dbo_T_ORDER_SEAT_HIST.order_no, dbo_T_BATCH.batch_no
    HAVING (((dbo_T_BATCH.batch_no)=83881))
    ORDER BY dbo_T_ORDER_SEAT_HIST.customer_no;

Children
  • $organization in reply to Former Member

    Thanks Carol

     

    Harpreet Gangyan | Database Analyst

    THE

    Level 4 TSB Building| PO BOX 5143, Wellesley Street | Auckland 1411, New Zealand
    T: +64 9 357 3351     | F: +64 9 357 3359 | www.the-edge.co.nz

    Please consider the environment before you print this email.

     

    Notice: This email is confidential. If it is not intended for you please do not read, distribute or copy the email or any attachments.
    Please notify the sender that you have received the message in error and delete the

    original message and any attachments.
    Please note that any views expressed in this email may be those of the individual sender and may not necessarily reflect the views of THE EDGE®.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Carol Ann Vinson
    Sent: Wednesday, 10 June 2009 13:49
    To: Harpreet Gangyan
    Subject: Re: [Tessitura Ticketing Forum] Orders under batch print

     

    I use access for this sort of thing.  Here's the SQL statement:
    SELECT dbo_T_ORDER_SEAT_HIST.customer_no, dbo_T_ORDER_SEAT_HIST.order_no, dbo_T_BATCH.batch_no
    FROM dbo_T_ORDER_SEAT_HIST INNER JOIN dbo_T_BATCH ON dbo_T_ORDER_SEAT_HIST.batch_no = dbo_T_BATCH.batch_no
    WHERE (((dbo_T_ORDER_SEAT_HIST.event_code)=2) AND ((dbo_T_ORDER_SEAT_HIST.event_date)>=#6/9/2009#))
    GROUP BY dbo_T_ORDER_SEAT_HIST.customer_no, dbo_T_ORDER_SEAT_HIST.order_no, dbo_T_BATCH.batch_no
    HAVING (((dbo_T_BATCH.batch_no)=83881))
    ORDER BY dbo_T_ORDER_SEAT_HIST.customer_no;

    From: Harpreet Gangyan <bounce-harpreetsinghgangyan5939@tessituranetwork.com>
    Sent: 6/9/2009 5:05:20 PM

    HI,

    Is there a way to find out orders printed under certain batch print?

    Thanks

    Harpreet




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!