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
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
Ooo thanks Beth!
I'll have a look and play.
YES!! That totally worked thanks Beth!!!