Posted by M Bourgon on 01/19/06 22:49

I 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.

[Back to original message]