Is there a way to pull a list by price zone? We have a performance with a VIP price zone and I need to pull a list for parking. I can't figure this out, I can pull a list by the price of the ticket, but that does not help me for complimentary seats in that section. Help?
If you are pulling your list using ticket history, you can look at what information your ticket history table is holding. In our ticket history, zone information is in the location field, along with price type, row, and seats. Using the Manual Edit, I have the following (to find all balcony seats in a particular theater):
Select Distinct a.customer_no
From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)
JOIN vs_tck_hist e (NOLOCK) ON a.customer_no = e.customer_no
Where IsNull(a.inactive, 1) = 1
AND (e.location like '%Balc%' or e.location like '%er Bal%')
AND e.performance_name in (select perf_code from VS_PERF where facility_no = 60)
AND e.season in (82)
Lucie