INSERT INTO BV_W001 SELECT 'a7c9f397440a5ec6e6278e1182cbd828',000000,'0',MEISAI.VKEY3 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,SUM(CASE MEISAI.VPERIOD WHEN '201102' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201103' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201104' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201105' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201106' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201107' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201108' THEN MEISAI.VD1 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD1 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '201102' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201103' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201104' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201105' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201106' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201107' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201108' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN 0 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '201102' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201103' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201104' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201105' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201106' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201107' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201108' THEN MEISAI.VD4 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN MEISAI.VD4 ELSE 0 END)
,SUM(CASE MEISAI.VPERIOD WHEN '201102' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201103' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201104' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201105' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201106' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201107' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '201108' THEN 0 ELSE 0 END) ,SUM(CASE MEISAI.VPERIOD WHEN '' THEN 0 ELSE 0 END)
FROM WVIEW0011_YYYYMM MEISAI
WHERE  MEISAI.VPERIOD BETWEEN '201102' AND '201108'
GROUP BY MEISAI.VKEY3

SELECT VPERIOD
,' ',' ',VKEY3,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',SUM(VD1),0,SUM(VD4),0
FROM
WVIEW0011_YYYY
WHERE
 VPERIOD BETWEEN '2011' AND '2011'
GROUP BY VPERIOD
 ,VKEY3