update [table]
set
a=case d when 100 then 1 when 200 then 4 when 300 then 7 when 400 then 11 else a end,
b=case d when 100 then 2 when 200 then 5 when 300 then 8 when 400 then 22 else b end,
b=case d when 100 then 3 when 200 then 6 when 300 then 9 when 400 then 33 else c end
set
a=case d when 100 then 1 when 200 then 4 when 300 then 7 when 400 then 11 else a end,
b=case d when 100 then 2 when 200 then 5 when 300 then 8 when 400 then 22 else b end,
b=case d when 100 then 3 when 200 then 6 when 300 then 9 when 400 then 33 else c end
set A=case D when 100 then 1 when 200 then 4 when 300 then 7 when 400 then 11 end,
B=case D when 100 then 2 when 200 then 5 when 300 then 8 when 400 then 22 end,
C=case D when 100 then 3 when 200 then 6 when 300 then 9 when 400 then 33 end
set A=(case D when 100 then 1 when 200 then 4 when 300 then 7 when 400 then 11 else A end),
B=(case D when 100 then 2 when 200 then 5 when 300 then 8 when 400 then 22 else B end),
C=(case D when 100 then 3 when 200 then 6 when 300 then 9 when 400 then 33 else A end)
set
a=case d when 100 then 1 when 200 then 4 when 300 then 7 when 400 then 11 else a end,
b=case d when 100 then 2 when 200 then 5 when 300 then 8 when 400 then 22 else b end,
c=case d when 100 then 3 when 200 then 6 when 300 then 9 when 400 then 33 else c end