I've tried that before.

I sent the output to a file and here is what I get:

col_1 ...

Thank you for providing a solution so quickly.

Sorry for delay and thanks for your help.

I ended up setting it to read_only.

Thank you very much, it worked for me.

What is your blog URL?

Thank you for replies. Does it matter if I am running 64bit installation of sql server?

Thank you, that worked. Was trying to avoid temp tables if possible.

Thank you, that worked well for me.

Will this update all rows in the tableB?

I need to update rows that are different.

Sorry Dwain for not mentioning you. I just didn't test yours yet.

I was asked to clean up data. The column that I am looking at (nvarchar(20)) contains tax id values.

I needed to identify rows where tax id value contains same digits...

Thanks you all for your replies. I have some options now.

I know I didn't ask for it in the original post, but is there a way to account for any digit?

This work fine, just looking for a shortcut.

SELECT *

...

Thank you all for replies,

It's an interesting problem and I thought it would be fun to try taking a crack at it, but I agree with you, Eugene that it...

Thanks for reply,

I've changed "begin tran" to "BEGIN DISTRIBUTED TRAN", but still getting the same error.

Is there anything else I need to change?

David,

I don't have any other supporting data. What I have is inconsistent.

In the costco example, it should be one parent company, not multiple stores.

Thanks,