Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
grothwell
Starting Member
1 Post |
 Posted - 2005-03-25 : 03:24:18
|
| Sales transactions accumulate into a WIP file on a daily basis. These need to be uploaded into the monthly file each day, but only to include those transactions that have not been uploaded in previous days. It is not an option to clear down the WIP file on a daily basis. What is the most efficient way to upload only the unique records from the daily file, whilst being sure that no transactions ever go astray? |
|
|
|
|
|
Append tran recs from daily to monthly file