TRUNCATE TABLE AP_SOKUHODT;
COMMIT;

<!--MGREPEAT-->

INSERT INTO AP_SOKUHODT
SELECT
 <!--MG_sokuhokbn-->
 ,<!--MG_sokuhono-->
 ,<!--MG_keyname-->
 ,<!--MG_midashi-->
 ,VPERIOD
 ,SUM(<!--MG_valuename-->)
FROM
 <!--MG_datasource-->
WHERE
 <!--MG_daterange-->
GROUP BY
 VPERIOD
 ,<!--MG_keyname-->
;
COMMIT;

<!--MGENDREPEAT-->

EXIT