By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

How can I update several (not all) fields in table A from table B for replication?

P: n/a
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.

Jan 19 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.