Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Recover Open Orders from Event Log
I have a table that is an event log of order information. Each order may have multiple entries - Placed, Acknowledged, Filled, Cancelled, Complete. I'd like to recover all records for a particular order only if it is not COMPLETE. Table looks as follows: create table orders (...
