UPDATE t
SET t.InstCode = t1.InstCode
FROM table t
INNER JOIN table t1
ON t1.ProcessCode = t.ProcessCode
AND t1.Date = t.Date
AND t1.TraceNumber = t.TraceNumber
WHERE t1.InstCode IS NOT NULL
AND t.InstCode IS NULL
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Copy a Data in a Row then Insert to Another Row
Posted - 10/17/2012 : 10:06:51
