Hi All,
I need to calculate how many seats were made available to a particular Price Type for the current and past Production Seasons and I'm struggling with how the tables link.
I've started with Perf_price_type and specified the price type id, joined T_PERF to get the correct prod_season_no's, then joined T_PERF_PRICE, T_ZONE, T_ZMAP, T_SMAP & T_SEAT to arrive at counting the number of seats that were allocated.
However, my calculations don't add up to the number pulled by my colleague via T-Stats, and she assures me that the T-Stats calculation is accurate.
I can post the SQL, but it's currently very simple and would make you laugh. If anyone is doing this in a report, I'd love to see where I'm going wrong.
Thanks, Debbie
Hi Debbie,
I just emailed you a stored procedure I created to pull capacity by price zone and perf along with a screen shot of the report layout using the query for the dataset. Please feel free to email/call if you have any questions.
Sara
Thanks Sara, that looks like exactly what I need. I'm really very grateful, I've been pulling my hair out!
Debbie