Your help please.
I have a database that has 2 tables with monetary values in them.
I have a need to remove all the records that have 0.00 into a database and maintain this database by moving all 0.00 records on a monthly basis.
What I am thinking of doing first off is
- copy the live database
- Remove all records with 0.00 from live database
- On a monthly basis move all records that have 0.00 to the copied database
I do not know how to accomplish item 3 above. Could you help me with this part please.
Thanks for your help.