We had a problem with Transcend last month where our batch numbers matched for a short time. During that week the first batch would post, the second would come back rejected as a dupe. Now we want to re-submit those batches. First though, we want to email our constituents to let them know that a small percentage of these sales did not go through and will be resubmitted and to call us with questions, etc. etc.
Web sales weren't affected.
Here's the question:
How can I pull a list of single ticket buyers for a specific date range where the moto ID is 102 or 101?
select distinct a.customer_no, a.pmt_dt, a.pmt_amt, a.pmt_method, b.description
from T_PAYMENT a
join TR_PAYMENT_METHOD b on b.id = a.pmt_method
where a.pmt_dt between '12/1/2014' and '1/1/2015'
and a.pmt_method in (14,15,16,17)
______________________________Lucie Spieler