DELIMITER //

CREATE DEFINER=`spcsta5`@`cpe-67-255-194-115.maine.res.rr.com` PROCEDURE compareAllMeterReads (IN starting_date datetime, IN ending_date_limit datetime)

BEGIN

	DECLARE audit_date DATETIME;
	
	SET audit_date = starting_date;
	
		
	WHILE (audit_date < ending_date_limit) DO
		CALL compareMeterReads(audit_date);
				
		SET audit_date = DATE_ADD(audit_date, INTERVAL 1 DAY);
	
	END WHILE;

END //

DELIMITER ;