We are in the process of rezoning. I need a query that will list all seat numbers of all unpaid and unreserved E holds not assigned to any patron number, grouped by Performance. I will need to run this query every day so we can rezone the price for those specific seats.
Eventually, I'd like a report that our BO Manager can run through Tessitura each day.
I appreciate your sql-scripting assistance! Thanks!
That looks like the report that will work! Thanks! ----- Original Message ----- From: Tessitura Technical Forum <forums-technical@tessituranetwork.com> To: Randall A. Mitchell Sent: Thu Jul 22 12:47:25 2010 Subject: Re: [Tessitura Technical Forum] SQL Query help Hi Randall, Have you tried the canned report "Hold Code Report (New)" I may be misunderstanding what you need but it seems like it would accomplish what you are trying to do. From: Randall Mitchell <bounce-randallmitchell8646@tessituranetwork.com> Sent: 7/22/2010 1:06:08 PM We are in the process of rezoning. I need a query that will list all seat numbers of all unpaid and unreserved E holds not assigned to any patron number, grouped by Performance. I will need to run this query every day so we can rezone the price for those specific seats. Eventually, I'd like a report that our BO Manager can run through Tessitura each day. I appreciate your sql-scripting assistance! Thanks! 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!