UPDATE Client
> SET Address=o.Address FROM Client m
> JOIN MyOtherServer.MyDatabase.dbo.Client o on o.Numero=m.Numero