>I have a field from a table in a database which I need to update from the same table in the same database but from another server. Both tables are the same. I just need to fix all the records with the same values as the other table as one SQL select I did emptied the related field.
>
>As this is from two different servers, do I need to do that in two steps or because the SSMS can see both servers there would be a way to synchronize that in one command?
[Update]Misunderstood the question, sorry[/Update]
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges