by "Plamen Ratchev" <Plamen@[EMAIL PROTECTED]
>
May 8, 2008 at 09:37 AM
On SQL Server 2005 you can use CTE to perform the update:
WITH UpdateSet
AS
(SELECT theUpdatedValue, theOtherValue, theTop, theValue
FROM T1
JOIN T2
ON T1.theID = T2.theKey)
UPDATE UpdateSet
SET theUpdatedValue = theTop,
theOtherValue = theValue;
HTH,
Plamen Ratchev
http://www.SQLStudio.com
