| 针对yddw表的每一个YDDWSYH索引号 需要在另外一个表插入5条数据 对应sql是 --地均税收 insert into GYYD_PGXJG t select yddwsyh,00,00, case when djss>32 then 40 when 20＜djss and djss<=32 then 30 when 10＜djss and djss<=20 then 24 when 5＜djss and djss<=10 then 16 when 5>=djss then 8 else 999 end,sys_guid() from yddw where yddwsyh='321112000093'; --地均营业收入 insert into GYYD_PGXJG t select yddwsyh,00,01, case when djsr>100 then 20 when 75＜djsr and djsr<=100 then 16 when 50＜djsr and djsr<=75 then 12 when 25＜djsr and djsr<=5 then 8 when 5>=djsr then 4 else 999 end,sys_guid() from yddw where yddwsyh='321112000093'; --地均从业人员 insert into GYYD_PGXJG t select yddwsyh,00,02, case when djcyry>800 then 20 when 350＜djcyry and djcyry<=800 then 16 when 156＜djcyry and djcyry<=350 then 12 when 128＜djcyry and djcyry<=156 then 8 when 128>=djcyry then 4 else 999 end,sys_guid() from yddw where yddwsyh='321112000093'; --人均上交税金 insert into GYYD_PGXJG t select yddwsyh,00,03, case when (case when CYRY=0 then 0 else nvl(ROUND(SJSJ/CYRY,2),0.0) end )>200 then 10 when 100＜(case when CYRY=0 then 0 else nvl(ROUND(SJSJ/CYRY,2),0.0) end ) and (case when CYRY=0 then 0 else nvl(ROUND(SJSJ/CYRY,2),0.0) end )<=200 then 8 when 50＜(case when CYRY=0 then 0 else nvl(ROUND(SJSJ/CYRY,2),0.0) end ) and (case when CYRY=0 then 0 else nvl(ROUND(SJSJ/CYRY,2),0.0) end )<=100 then 6 when 10＜(case when CYRY=0 then 0 else nvl(ROUND(SJSJ/CYRY,2),0.0) end ) and (case when CYRY=0 then 0 else nvl(ROUND(SJSj/CYRY,2),0.0) end )<=50 then 4 when 10>=(case when CYRY=0 then 0 else nvl(ROUND(SJSJ/CYRY,2),0.0) end ) then 2 else 999 end,sys_guid() from yddw where yddwsyh='321112000093'; --人均营业收入 insert into GYYD_PGXJG t select yddwsyh,00,04, case when (case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end )>200 then 10 when 100＜(case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end ) and (case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end )<=200 then 8 when 50＜(case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end ) and (case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end )<=100 then 6 when 15＜(case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end ) and (case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end )<=50 then 4 when 15>=(case when CYRY=0 then 0 else nvl(ROUND(YYSR/CYRY,2),0.0) end ) then 2 else 999 end,sys_guid() from yddw where yddwsyh='321112000093'; 但是yddw表的yddwsyh 有30万条。怎么能快速插入啊 |
