INSERT INTO BV_W001 SELECT '960kjj328svz5n824l317l000k0k0002',000000,'0',MEISAI.VKEY1,' ',' ',' ' ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,SUM(CASE MEISAI.VPERIOD WHEN '201704' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201705' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201706' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201707' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201708' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201709' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201710' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201711' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201712' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201801' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201802' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201803' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201704' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201705' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201706' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201707' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201708' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201709' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201710' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201711' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201712' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201801' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201802' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201803' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201704' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201705' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201706' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201707' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201708' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201709' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201710' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201711' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201712' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201801' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201802' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201803' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201604' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201605' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201606' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201607' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201608' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201609' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201610' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201611' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201612' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201701' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201702' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201703' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201704' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201705' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201706' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201707' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201708' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201709' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201710' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201711' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201712' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201801' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201802' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201803' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201704' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201705' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201706' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201707' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201708' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201709' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201710' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201711' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201712' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201801' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201802' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201803' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201704' AND MEISAI.VPERIOD >= '201605' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201705' AND MEISAI.VPERIOD >= '201606' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201706' AND MEISAI.VPERIOD >= '201607' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201707' AND MEISAI.VPERIOD >= '201608' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201708' AND MEISAI.VPERIOD >= '201609' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201709' AND MEISAI.VPERIOD >= '201610' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201710' AND MEISAI.VPERIOD >= '201611' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201711' AND MEISAI.VPERIOD >= '201612' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201712' AND MEISAI.VPERIOD >= '201701' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201801' AND MEISAI.VPERIOD >= '201702' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201802' AND MEISAI.VPERIOD >= '201703' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201803' AND MEISAI.VPERIOD >= '201704' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '' AND MEISAI.VPERIOD >= '' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201704' AND MEISAI.VPERIOD >= '201605' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201705' AND MEISAI.VPERIOD >= '201606' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201706' AND MEISAI.VPERIOD >= '201607' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201707' AND MEISAI.VPERIOD >= '201608' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201708' AND MEISAI.VPERIOD >= '201609' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201709' AND MEISAI.VPERIOD >= '201610' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201710' AND MEISAI.VPERIOD >= '201611' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201711' AND MEISAI.VPERIOD >= '201612' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201712' AND MEISAI.VPERIOD >= '201701' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201801' AND MEISAI.VPERIOD >= '201702' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201802' AND MEISAI.VPERIOD >= '201703' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '201803' AND MEISAI.VPERIOD >= '201704' THEN 0 ELSE 0 END) ,SUM(CASE WHEN MEISAI.VPERIOD <= '' AND MEISAI.VPERIOD >= '' THEN 0 ELSE 0 END) FROM WVIEW0011_YYYYMM MEISAI WHERE MEISAI.VPERIOD BETWEEN '201604' AND '201803' GROUP BY MEISAI.VKEY1 ,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,509,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ' SELECT VPERIOD ,VKEY1,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',SUM(VD4),0,SUM(VD4),0,SUM(VD4),0 FROM WVIEW0011_YYYY WHERE VPERIOD BETWEEN '2016' AND '2017' GROUP BY VPERIOD ,VKEY1 SELECT VPERIOD ,VKEY1,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',SUM(VD4),0,SUM(VD4),0,SUM(VD4),0 FROM WVIEW0011_HALFYEAR WHERE VPERIOD BETWEEN '201602' AND '201702' GROUP BY VPERIOD ,VKEY1 VPERIOD BETWEEN '0001' AND ''