• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 13 views
  • Users 0 members are here
Related

Next Concert Date

Jan LaRocque
$organization

I have just been asked to set up an Output criteria to show what a customer's next concert date is.  I know how to set up most recent, first concert; highest or lowest amount.   But I don't have a clue how to set up next ticket date.   Does anyone have a suggestion?

Jan LaRocque

Houston Symphony

Parents
  • $organization

    Thanks, Tom.  




    Tom Brown <bounce-tombrown3568@tessituranetwork.com>
    Sent by: Tessitura Technical Forum <forums-technical@tessituranetwork.com>

    03/26/2012 07:51 PM

    Please respond to
    Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To
    		<jan.larocque@houstonsymphony.org>
    cc
    Subject
    		RE: [Tessitura Technical Forum] Next Concert Date





    I’m not at SQL server management studio so my syntax will not be perfect here.  However the idea is:
    You want to group all future ticket (tickets with perf_dt >= getdate() ) by customer_no. 
    And for each customer_no you are looking for the ticket with the min(perf_dt). 
     
    --Tom
     
    P.S. If this helps you work out the code let me know.  This sounds useful.
     
     
    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jan LaRocque
    Sent:     Monday, March 19, 2012 4:36 PM
    To:     Thomas Brown
    Subject:     [Tessitura Technical Forum] Next Concert Date
     

    I have just been asked to set up an Output criteria to show what a customer's next concert date is.  I know how to set up most recent, first concert; highest or lowest amount.   But I don't have a clue how to set up next ticket date.   Does anyone have a suggestion?

    Jan LaRocque

    Houston Symphony



    This message was sent automatically to you by     www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!




    This message was sent automatically to you by     www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Reply
  • $organization

    Thanks, Tom.  




    Tom Brown <bounce-tombrown3568@tessituranetwork.com>
    Sent by: Tessitura Technical Forum <forums-technical@tessituranetwork.com>

    03/26/2012 07:51 PM

    Please respond to
    Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To
    		<jan.larocque@houstonsymphony.org>
    cc
    Subject
    		RE: [Tessitura Technical Forum] Next Concert Date





    I’m not at SQL server management studio so my syntax will not be perfect here.  However the idea is:
    You want to group all future ticket (tickets with perf_dt >= getdate() ) by customer_no. 
    And for each customer_no you are looking for the ticket with the min(perf_dt). 
     
    --Tom
     
    P.S. If this helps you work out the code let me know.  This sounds useful.
     
     
    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jan LaRocque
    Sent:     Monday, March 19, 2012 4:36 PM
    To:     Thomas Brown
    Subject:     [Tessitura Technical Forum] Next Concert Date
     

    I have just been asked to set up an Output criteria to show what a customer's next concert date is.  I know how to set up most recent, first concert; highest or lowest amount.   But I don't have a clue how to set up next ticket date.   Does anyone have a suggestion?

    Jan LaRocque

    Houston Symphony



    This message was sent automatically to you by     www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!




    This message was sent automatically to you by     www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Children
No Data