It's early (6am!) and I'm trying this without much success:
DELETE FROM eiwdb!jobs WHERE nJobID in (select njobid FROM crap)
Obviously you can see I've got a list of jobs that I don't want to keep
in my cursor CRAP. What's the easiest way (other than me writing a SCAN
loop) to delete these buggers?
I'm not fully awake yet but the only thing I can think of at the moment
is a SCAN loop doing a SEEK and DELETE.
TIA!
--
Michael J. Babcock, MCP
President/CSA, MB Software Solutions, LLC
http://mbsoftwaresolutions.com
"Bettering your bottom line by helping you work smarter, not harder,
with custom software solutions."
©2004 Michael J. Babcock |
