Col 1	Col 2	Col 3	Col 4
10000	20.00	1	0
10001	0	0	1
10002	15.00	1	0
10003	0	0	0

Col 1	Col 2	Col 3	Col 4
10000	20.00	1	0
10001	20.00	1	0
10002	20.00	1	0
10003	20.00	1	0

UPDATE {table}
SET [Col 2]=(SELECT [Col 2] FROM {table} WHERE [Col 1]=10000)
  , [Col 3]=(SELECT [Col 3] FROM {table} WHERE [Col 1]=10000)
  , [Col 4]=(SELECT [Col 4] FROM {table} WHERE [Col 1]=10000)

UPDATE a 
SET a.[Col 2] = b.[Col 2], 
	a.[Col 3] = b.[Col 3], 
	a.[Col 4] = b.[Col 4] 
JOIN [table] b ON b.[Col 1] = 10000 
WHERE a.[Col 1] > 10000 

DECLARE @Col2 decimal,@Col3 int,@Col4 int
SELECT @Col2 = [Col 2],@Col3 = [Col 3],@Col4 = [Col 4]
FROM [table]
WHERE [Col 1] = 10000 
UPDATE [table] 
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.

DECLARE @Col2 decimal,@Col3 int,@Col4 int
SELECT @Col2 = [Col 2],@Col3 = [Col 3],@Col4 = [Col 4]
FROM [table]
WHERE [Col 1] = 10000 
UPDATE [table] 
SET [Col 2] = @Col2, 
	[Col 3] = @Col3, 
	[Col 4] = @Col4 
WHERE [Col 1] > 10000