Hello,
We are working on setting up a new way to process complementary passes. Does anyone have an automated way to reschedule a performance daily that they'd be willing to share? I saw a similar post from several years ago where they wanted to use the query below but I am not getting any results from it:
UPDATE T_PERFSET perf_dt = GETDATE()WHERE perf_no = [comp performance]
Any help would be appreciated!
Lidija,
There are a few things to consider there. Price Type and MOS start/end dates for one. But yes, that script above WOULD indeed move the performance from its date/time was to the current moment. It would not "return" anything in the SSMS results grid because it is not a SELECT statement, but the update should work correctly. Additionally, Tessitura DOES now have the "reschedule" functionality native which can be used to produce the same results, though that is not "automated" as you stated you wanted above.
That all said, there are a few other thoughts and things that can be done. When it comes to comp tickets (and I see no reason why it could not work similarly for passes/admissions), what we do is issue comp vouchers which are then redeemed on the normal performance/event which tracks every other normal paid admission/ticket for a comp price type. Our box office simply returns the voucher and pulls a comp ticket. That voucher is set at the end of the season so it is valid to be issued/returned whenever we want to for the whole season. This way there is no semi-regular updating of performance dates/times. Just a thought.
Best of luck,
John A. Moskal II