Home Forums SQL Server 2005 SQL Server Newbies Update Statement Creates Unwanted Nulls RE: Update Statement Creates Unwanted Nulls
Lynn Pettis
SSC Guru
Points: 442467
More actions
January 19, 2010 at 3:33 pm
#1105760
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);