|
后来我将SQL语句修改后就可以执行了,如下:
Update SAT456 set"标准"=Round(case when "一级"='03' then
case "二级"
when '01' then 7780
when '02' then 7280
when '03' then 6780
when '04' then 6280
when '05' then 5780
when '06' then 5280
when '07' then 4780
when '08' then 4280
when '09' then 3780
end
when "一级"='04' then
case "二级"
when '01' then 5680
when '02' then 5280
when '03' then 4880
when '04' then 4480
when '05' then 4080
when '06' then 3680
when '07' then 3280
when '08' then 2880
when '09' then 2480
end
when "一级"='05' then
case "二级"
when '01' then 3840
when '02' then 3680
when '03' then 3520
when '04' then 3360
when '05' then 3200
when '06' then 3040
when '07' then 2880
when '08' then 2720
when '09' then 2560
when '10' then 2480
when '11' then 2400
when '12' then 2320
when '13' then 2240
when '14' then 2160
when '15' then 2080
when '16' then 2000
when '17' then 1920
when '18' then 1840
when '19' then 1760
when '20' then 1680
when '21' then 1600
when '22' then 1520
when '23' then 1440
end
when "一级"='06' then
case "二级"
when '01' then 3200
when '02' then 3040
when '03' then 2880
when '04' then 2720
when '05' then 2560
when '06' then 2400
when '07' then 2240
when '08' then 2080
when '09' then 1920
when '10' then 1840
when '11' then 1760
when '12' then 1680
when '13' then 1600
when '14' then 1520
when '15' then 1440
when '16' then 1360
when '17' then 1280
when '18' then 1200
when '19' then 1120
when '20' then 1040
when '21' then 960
when '22' then 880
when '23' then 800
end
when "一级"='07' then
case "二级"
when '01' then 2560
when '02' then 2400
when '03' then 2240
when '04' then 2080
when '05' then 1920
when '06' then 1760
when '07' then 1600
when '08' then 1440
when '09' then 1280
when '10' then 1240
when '11' then 1200
when '12' then 1160
when '13' then 1120
when '14' then 1080
when '15' then 1040
when '16' then 1000
when '17' then 960
when '18' then 920
when '19' then 880
when '20' then 840
when '21' then 800
when '22' then 760
when '23' then 720
end
when "一级"='08' then
case "二级"
when '01' then 1840
when '02' then 1760
when '03' then 1680
when '04' then 1600
when '05' then 1520
when '06' then 1440
when '07' then 1360
when '08' then 1280
when '09' then 1200
when '10' then 1160
when '11' then 1120
when '12' then 1080
when '13' then 1040
when '14' then 1000
when '15' then 960
when '16' then 930
when '17' then 900
when '18' then 870
when '19' then 840
when '20' then 780
when '21' then 720
when '22' then 660
when '23' then 600
end
when "一级"='09' then
case "二级"
when '01' then 1520
when '02' then 1440
when '03' then 1360
when '04' then 1280
when '05' then 1200
when '06' then 1120
when '07' then 1040
when '08' then 960
when '09' then 880
when '10' then 860
when '11' then 840
when '12' then 820
when '13' then 800
when '14' then 780
when '15' then 770
when '16' then 760
when '17' then 750
when '18' then 730
when '19' then 700
when '20' then 670
when '21' then 640
when '22' then 610
when '23' then 580
end
when "一级"='10' then
case "二级"
when '01' then 1200
when '02' then 1120
when '03' then 1040
when '04' then 960
when '05' then 880
when '06' then 800
when '07' then 720
when '08' then 640
when '09' then 560
when '10' then 550
when '11' then 540
when '12' then 540
when '13' then 540
when '14' then 530
when '15' then 530
when '16' then 520
when '17' then 520
when '18' then 510
when '19' then 500
when '20' then 490
when '21' then 480
when '22' then 470
when '23' then 460
end
when "一级"='11' then
case "二级"
when '01' then 880
when '02' then 830
when '03' then 780
when '04' then 730
when '05' then 680
when '06' then 630
when '07' then 580
when '08' then 530
when '09' then 480
when '10' then 480
when '11' then 470
when '12' then 470
when '13' then 460
when '14' then 460
when '15' then 450
when '16' then 450
when '17' then 440
when '18' then 430
when '19' then 420
when '20' then 410
when '21' then 400
when '22' then 400
when '23' then 400
end
else 0
end,8)
|
