计算数据库中数据总和的存储过程

需改进的地方: 年, 月, 需要改进

DROP PROCEDURE IF EXISTS `pSum_TABLE_ROWS`;
CREATE DEFINER=`root`@`%` PROCEDURE `pSum_TABLE_ROWS`(
    IN inDBName varchar(40),
    IN inTABLEPrefix varchar(40),
    IN inYear INT,
    IN inMonth INT,
    IN inDayStart INT,
    IN inHourStart INT,
    IN inDayEnd INT,
    IN inHourEnd INT
)
BEGIN
    DECLARE v_tableName varchar(40);
    DECLARE vFLAG INT DEFAULT 0;
    DECLARE vSameDayFLAG INT DEFAULT 0;

    DECLARE vDay_start INT DEFAULT 0;
    DECLARE vDay_end INT DEFAULT 0;
    DECLARE vHour_start INT DEFAULT 0;
    DECLARE vHour_end INT DEFAULT 0;

    DECLARE szMonth char(10);
    DECLARE szDay char(10);
    DECLARE szHour char(10);