CREATE PROCEDURE `proc_temp_calendar`(
        IN begin_date DATE,
        IN end_date DATE
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
    
    SET @last_date = begin_date;
    
    DROP TABLE IF EXISTS temp_calendar;
    
    CREATE TEMPORARY TABLE temp_calendar(
           date DATE NOT NULL,
           KEY days (date)
    ) ENGINE = MyIsam;
    
    WHILE @last_date <= end_date DO
       insert into temp_calendar(date) values(@last_date);
       SET @last_date = DATE_ADD(@last_date, interval 1 day);
    END WHILE;
  
END;