| 20 | 6 | CPROMPT | {Run Every 1 hourofday} | 1 | 1 | My B2B Report;23:00;nonulls | select orders.transactionid, company, name, address, city, state, zip, country, phone, 'Prepaid', 'Package', shipmethod, STR( sum( ShipWt * quantity ),10,2), email, 'Y', ' ' From OrderLineItem, addresses, orders, Items, orderspostproc where OrderLineItem.ShiptoAddressID = addresses.addressCodeId AND OrderLineItem.transactionid = orders.transactionid AND OrderLineItem.transactionid = orderspostproc.transactionid AND OrderLineItem.ItemCodeId = Items.ItemCodeId AND Items.PayLoadloc like '#%' AND ProcessStep = 1 AND orders.date < CAST( CAST ( DATEPART(MONTH, getdate() ) AS char ) + '/' + CAST ( DATEPART(DAY, getdate() ) AS char ) + '/' + CAST ( DATEPART(YEAR, getdate() ) AS char ) + ' ' + ' 23:00' + ' ' AS datetime) group by orders.transactionid, company, name, address, city, state, zip, country, phone, shipmethod, email order by orders.transactionid; Select orders.transactionid, serializer, date, LineItemID, sku, fullname, itemparameter, quantity, STR( OrderLineItem.priceea, 10,2), shipmethod, STR( ShipWt * quantity, 10,2), requiredshipdate, name, company, address, city, state, zip, country, phone, email, fax, altphone, international, STR( subtotalitems, 10,2), STR( subtotalshipping, 10,2), STR( subtotalsalestax, 10,2), STR( totalamount, 10,2) From OrderLineItem, addresses, orders, Items, orderspostproc where OrderLineItem.ShiptoAddressID = addresses.addressCodeId AND OrderLineItem.transactionid = orders.transactionid AND OrderLineItem.transactionid = orderspostproc.transactionid AND OrderLineItem.ItemCodeId = Items.ItemCodeId AND Items.PayLoadloc like '#%' AND ProcessStep = 1 AND orders.date < CAST( CAST ( DATEPART(MONTH, getdate() ) AS char ) + '/' + CAST ( DATEPART(DAY, getdate() ) AS char ) + '/' + CAST ( DATEPART(YEAR, getdate() ) AS char ) + ' ' + ' 23:00' + ' ' AS datetime) order by orders.transactionid | youremail@yourbiz.com | 2004-08-21 13:12:00.000 | 2004-08-21 13:11:19.000 | 0 | FulFillment Job ran okay |