INSERT INTO BV_W001 SELECT '3193ed14668b57ab9fd1732abaa06fd4',000000,'0',MEISAI.VKEY7 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,SUM(CASE MEISAI.VPERIOD WHEN '201001' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201002' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201003' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201004' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201005' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201006' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201007' THEN MEISAI.VD2 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD2 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '201001' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201002' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201003' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201004' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201005' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201006' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201007' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN 0 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '201001' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201002' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201003' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201004' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201005' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201006' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201007' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD1 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '201001' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201002' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201003' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201004' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201005' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201006' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201007' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN 0 ELSE 0 END)
FROM V_B0801M MEISAI
WHERE  MEISAI.VPERIOD BETWEEN '201001' AND '201007'
GROUP BY MEISAI.VKEY7

,' ',' ',' ',' ',' ',' ',VKEY7,' ',' ',' ',' ',' ',' ',' ',' ',SUM(VD2),0,SUM(VD1),0
 VPERIOD BETWEEN '201001' AND '201007'
 ,VKEY7

 VPERIOD BETWEEN '2011' AND '2011'