update dbo.xTest set
    location = xu.location
from
    dbo.xTest xt
    inner join dbo.xUpdate xu
        on (xt.name = xu.name);