> This is not sup****ted in MSsql.
>
> update T1 set (theUpdatedValue, theOtherValue) =
> (select theTop, theValue from T2 where T2.theKey = T1.theID)
>
> Is there a workaround?
You can use the proprietary UPDATE...FROM syntax:
UPDATE T1
SET
theUpdatedValue = T2.theTop,
theOtherValue = T2.theValue
FROM T2
WHERE
T2.theKey = T1.theID
Or with an alias:
UPDATE a
SET
theUpdatedValue = b.theTop,
theOtherValue = b.theValue
FROM T1 a
JOIN T2 b ON
b.theKey = a.theID
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Leif Neland" <leif@[EMAIL PROTECTED]
> wrote in message
news:4822d7e6$0$56781$edfadb0f@[EMAIL PROTECTED]
> This is not sup****ted in MSsql.
>
> update T1 set (theUpdatedValue, theOtherValue) =
> (select theTop, theValue from T2 where T2.theKey = T1.theID)
>
> Is there a workaround?
>
> Other than doing it in a loop from eg asp, over either fields (one
> statement
> per field), or over records (a query with a loop which for each row does
a
> select from one table, update other table with the selected values.)
>
>
|
