• Also, give this code a try in a test environment.

    update dbo.xTest set

    location = xu.location

    from

    dbo.xTest xt

    inner join dbo.xUpdate xu

    on (xt.name = xu.name);