| 19 | 33 | CPROMPT |
{Run Every 13 hourofday} |
1 |
1 |
select top 250 lineitemid, addresses.email, date, addresses.name, items.fullname, orderlineitem.orderflags
from
orders, customers, orderlineitem, items, addresses
where
orders.customerid = customers.customerid and
orders.transactionid = orderlineitem.transactionid and
items.itemcodeid = orderlineitem.itemcodeid and
customers.addressid = addresses.addresscodeid and
orderlineitem.orderflags not like '%icrmabandoncarttickle%' and
status like '%{under construction}%'
order by date desc
|
update orderlineitem set orderlineitem.OrderFlags = orderlineitem.OrderFlags + ',ICRMABANDONCARTTICKLE'
where orderlineitem.OrderFlags is not null and LineItemID = [0];
update orderlineitem set orderlineitem.OrderFlags = 'ICRMABANDONCARTTICKLE'
where orderlineitem.OrderFlags is null and LineItemID = [0]
|
122736;Special offer from CPrompt;sales@mybiz.com;cccopy@mybiz.com |
2004-08-21 13:12:00.000 | 2004-08-21 13:11:19.000 | 0 | FulFillment Job ran okay |