ryan.mcatee (3/8/2013)
I think you want something like this?
or
UPDATE a
SET a.[Col 2] = b.[Col 2],
a.[Col 3] = b.[Col 3],
a.[Col 4] = b.[Col 4]
JOIN
b ON b.[Col 1] = 10000
WHERE a.[Col 1] > 10000
or
DECLARE @Col2 decimal,@Col3 int,@Col4 int
SELECT @Col2 = [Col 2],@Col3 = [Col 3],@Col4 = [Col 4]
FROM
WHERE [Col 1] = 10000
UPDATE
SET [Col 2] = @Col2,
[Col 3] = @Col3,
[Col 4] = @Col4
WHERE [Col 1] > 10000
Far away is close at hand in the images of elsewhere.
Anon.