INSERT INTO BV_W001 SELECT 'bad7a80459380e0c54c8a2a78323f8e3',000000,'0',MEISAI.VKEY8 ,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 '202401' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202402' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202403' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202404' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202405' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202406' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202407' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202408' THEN MEISAI.VD2 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '202401' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202402' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202403' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202404' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202405' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202406' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202407' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202408' THEN 0 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '202401' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202402' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202403' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202404' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202405' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202406' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202407' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202408' THEN 0 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '202401' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202402' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202403' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202404' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202405' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202406' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202407' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202408' THEN 0 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '202401' THEN MEISAI.VD3 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202402' THEN MEISAI.VD3 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202403' THEN MEISAI.VD3 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202404' THEN MEISAI.VD3 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202405' THEN MEISAI.VD3 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202406' THEN MEISAI.VD3 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202407' THEN MEISAI.VD3 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202408' THEN MEISAI.VD3 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '202401' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202402' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202403' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202404' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202405' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202406' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202407' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '202408' THEN 0 ELSE 0 END)
FROM WVIEW0041_YYYYMM MEISAI
WHERE MEISAI.VKEY1 = '0000572' AND MEISAI.VKEY13 = '4410153' AND MEISAI.VKEY14 = '4' AND MEISAI.VPERIOD BETWEEN '202401' AND '202408'
GROUP BY MEISAI.VKEY1 ,MEISAI.VKEY8 ,MEISAI.VKEY13 ,MEISAI.VKEY14

SELECT VPERIOD
,VKEY1,' ',' ',' ',' ',' ',' ',VKEY8,' ',' ',' ',' ',VKEY13,VKEY14,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',SUM(VD2),0,0,0,SUM(VD3),0
FROM
WVIEW0041_YYYY
WHERE
VKEY1 = '0000572' AND VKEY13 = '4410153' AND VKEY14 = '4' AND VPERIOD BETWEEN '' AND ''
GROUP BY VPERIOD
,VKEY1 ,VKEY8 ,VKEY13 ,VKEY14