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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-29 : 07:57:26
|
| Jeff writes "Hello,I am using sql-2k, I have a table called sales. Once a day I get a csv file for all sales from the last 30 days from another system. I need to import this file into the table. That part is easy. My problem is the file today has 10 records and the file tomorrow has the original 10 plus 2 new ones. I only want the new records added into the table. Any ideas or tips would be greatly appreciated. ThanksJeff" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-29 : 08:14:48
|
| Hello Jeff!Your best bet would be to use the other systems primary key (if there is one) to keep track of the rows. Or maybe there is some other combination of columns which is unique? Otherwise you are in trouble... |
 |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-07-29 : 10:55:15
|
| If you could provide a sample of the data, it may be helpful in guiding you to a solution. |
|
|
|
|
|
|
dealing with duplicate records