|
How to avoid duplication of the records when I make update!
Does anyone have any clear idea of how can the following be achieved?
I have two databases. The databases are the same. One is on the server and the other is on the client machine. Every day I need to back up the data from the client's database to the server's. But inside the tables I want to update only the last record (for the passed day). I do not need to update the records that are there already. ONLY THE LAST RECORD NEEDS TO BE UPDATED.
I suppose that the solution is somewhere in writing a query or asp code.
People, if you have any ideas, please, share them with me!
Thanks
|