Is there an easy way to delete all rows not updated when done updating
a db?
What in the world do you mean?
Hard to answer a question without any details or context to what
you're doing.
Jeff
purpleworkshops.com
I have a table of data that I update with a file. I would like to
delete all data that does not get updated.
We've done stuff like this before. One pattern that we used was:
1) At the beginning of the import process, we'd set a unique value
(like a timestamp/date)
2) We'd update an attribute in the table for all records with that value:
example: last_import = 20081231
3) then run your import/update process..
4) then delete any records that last_import != 20081231
voila!
Robby