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!

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!