Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI am trying to update the contents of table A (I'll use Northwind..Products as an example) with the data from any changed fields in Table B (which is a copy of Northwind..Products, but with some updated values). Table_A is replicated, so I would rather not update every field, but just the fields where the values are different. I could probably due it using dynamic SQL, but for many obvious reasons I'd prefer not to. And the reason for Table_B is replication - when we get a "comprehensive" file we delete and start anew (and yes, there's a reason for this as well), rather than just update the original. The only way I've thought of is to do one for each field, something like: update products set productname = products2.productname from products, products where products.id = products2.id and products.productname <> products2.productname update products set supplierid = products2.supplerid [...] Any help greatly appreciated. I considered trying some kind of CASE clause that would set it to its own value (set productname = products.productname), but that would (?) be considered a change and would be replicated.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread