Let's say xTest has 9 records and no nulls. xUpdate has 6 records. I am updating locations for 6 people. After I execute this statement, the remaining 3 records in xTest end up with nulls in location:
set location = (select [location] from xUpdate
where xTest.name = xUpdate.name)
Why am I getting nulls? I don't get nulls if my xUpdate file is the full dataset with the correct values.