Hi all,
We're trying to streamline ticket designs throughout our consortium. Has anybody created a query that will search for ticket designs that are attached to price types for performances that are currently on sale? If so, I would love to see the code.
Best,
Nick
Nick,
It depends what you use to determine which of your performances are “On Sale”, but if you are using the checkbox on the performance itself as the default over-ride for on/off-sale, this should do the trick to give you all currently actively used ticket designs. If you rely specifically on MOS/Price Type end dates, it should not be terribly difficult to modify this to fit that.
USE impresario
SELECT DISTINCT a.ticket_design_no,
b.description
FROM T_PERF_PRICE_TYPE a (NOLOCK)
JOIN T_DESIGN b (NOLOCK) ON a.ticket_design_no = b.design_no
WHERE a.perf_no IN (SELECT c.perf_no FROM T_PERF c (NOLOCK) WHERE c.avail_sale_ind = 'Y')
ORDER BY b.description
John
Hi John,
Thanks! That did the trick with a slight modification to use the default sales end dates since we don't use the onsale checkbox.
Thanks again!