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 |
|
katgirl67
Starting Member
4 Posts |
 Posted - 2001-03-30 : 15:46:04
|
| Here's my issue. I've got a table in my database of available products. Every month, I get a CSV update of those products from an external source. Of course, I can successfully import using DTS, but how can I update that table? I need to do it as an update because I need to keep the Primary Key the same for the product. I just want to update the information (descriptions, etc.) in the table should any of the fields change.I'm playing with laternate ways of doing this, I've imported the new table in and trying to write a "compare" script, but I'm getting stuck. I don't think what I'm doing is very efficient.Any advice is appreciated.Thank you! |
|
|
|
|
|
Globally updating a table