Well now you can't argue that you are big .

Knowing her... probabely never .

Maybe this can help.

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=225872

Don't have that book yet... where can I have a copy?

BTW you didn't even alter the site owner's message...

Wow... don't quit your day job .

Gone and back again .

The resolving part will be true in any engine, that's why you must always specify from which table the data is comming from (when a join is used). As...

My first question would be why are you using xml and what are you trying to do exactly?

My second question is can you drop the xml part of the equation??

It basically makes the code easier to read/debug. Other than that sql server won't see any difference ... Although I could imagine that...

if you run it like that,you can run the query once the fetch the value into a variable, then use the variable in the update. I thaught that this...

We need the tables ddl, sample data and required output to answer that one.

K, go back to my original solution or repost the actual needs you have so that you can update all those rows in a single pass.

Maybe... but I hope it's better than that .