Greetings,
I am trying to get a list of patrons who attended two or more performances from a list of specific performances. I'm trying to find a way to pull them usings extractions or T-Stats but I'm stuck. Anyone have any ideas?
Thanks!
Fantastic! Thank you so much Lucie!
Make a separate list, for each performance, of accounts with tickets.
Make a note of the list numbers. Let’s say that you are tracking three performances, and the resulting list numbers are 40933, 40932, and 40931.
Make a fourth list and go to manual edit. Paste the following code into the screen (replacing “40933,40932,40931” with the numbers of your lists):
Select Distinct a.customer_no
From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)
JOIN t_list_contents e (Nolock) ON e.customer_no = a.customer_no
Where IsNull(a.inactive, 1) = 1
AND e.list_no in (40933,40932,40931)
group by a.customer_no
HAVING COUNT(e.customer_no) > 1
That should give you everyone with 2 or more of the performances.
Lucie
______________________________Lucie SpielerIT Development and Training Manager
Florida Grand Opera