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

Output Set - Next Performance

Kelly Enderwick
$organization

Hello,

Has anyone created a output set for next performance date AND more specifically next performance date from a specific date. We are about to launch a phone campaign and as part of the conversion we want to recognize if the customer is coming to an event after that date (and if possible what that event is). Am I asking too much?

Thanks

Kelly 

Parents
  • $organization

    Hi Kelly!

    Couldn't you use a version of the code from TR_FLEX_HEADER_ELEMENT that pulls Next Perf for the constituent header?

    select top 1 CONVERT(varchar,perf_dt,1) + ' ' + perf_name from LVS_TKT_HIST where perf_dt >= GETDATE() and customer_no = @customer_no order by perf_dt

    I'd suppose you could then create a query parameter instead of using GETDATE() so you'd have your specific date...

    (Haven't tried this, but it just popped in my head...)

    Beth

Reply
  • $organization

    Hi Kelly!

    Couldn't you use a version of the code from TR_FLEX_HEADER_ELEMENT that pulls Next Perf for the constituent header?

    select top 1 CONVERT(varchar,perf_dt,1) + ' ' + perf_name from LVS_TKT_HIST where perf_dt >= GETDATE() and customer_no = @customer_no order by perf_dt

    I'd suppose you could then create a query parameter instead of using GETDATE() so you'd have your specific date...

    (Haven't tried this, but it just popped in my head...)

    Beth

Children