• Replies 3 replies
  • Subscribers 413 subscribers
  • Views 32 views
  • Users 0 members are here
Related

Subs with Single Tickets

Amy Aldrich
$organization

Hello,

We did a promotion in which subscribers who bought single tickets in addition to their subscription will receive some free coupons for parking. They get one coupon per single concert they bought. I am having trouble finding this information.

I tried to make an extraction, but I can't yield the results I am looking for. I need to be able to break it down by subs who bought 5 or more single concerts, subs who bought 4 single concerts, 3, 2 and 1.

Anybody have any suggestions for getting these 5 different groups? We don't have T-stats yet.

Thanks in advance!

Parents
  • $organization
    Thank you so very much!

    >>> "Lucie Spieler" 9/17/2010 1:41 PM >>>

    CORRECTION:

    Try this instead:

    Select Distinct a.customer_no
    From t_customer a (NOLOCK)
    JOIN vs_subscription_hist e (NOLOCK) ON a.customer_no = e.customer_no
    Where IsNull(a.inactive, 1) = 1
    AND e.season in (46)
    AND Exists (select customer_no from vs_tck_hist (NOLOCK) Where vs_tck_hist.customer_no = a.customer_no and price_type = 'I' and season in (46) group by customer_no Having count(distinct convert(char(12), performance_dt) + matinee_or_evening) = 2)

    Lucie



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • $organization
    Thank you so very much!

    >>> "Lucie Spieler" 9/17/2010 1:41 PM >>>

    CORRECTION:

    Try this instead:

    Select Distinct a.customer_no
    From t_customer a (NOLOCK)
    JOIN vs_subscription_hist e (NOLOCK) ON a.customer_no = e.customer_no
    Where IsNull(a.inactive, 1) = 1
    AND e.season in (46)
    AND Exists (select customer_no from vs_tck_hist (NOLOCK) Where vs_tck_hist.customer_no = a.customer_no and price_type = 'I' and season in (46) group by customer_no Having count(distinct convert(char(12), performance_dt) + matinee_or_evening) = 2)

    Lucie



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data