David,

Thanks very much.

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...