salix/db/routines/vn/procedures/timeControl_calculateAll.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`timeControl_calculateAll`(vDatedFrom DATETIME, vDatedTo DATETIME)
BEGIN

/**
 * @param vDatedFrom Fecha desde
 * @param vDatedTo Fecha hasta
 */

	CREATE OR REPLACE TEMPORARY TABLE tmp.`user` 
		SELECT w.id userFk
			FROM vn.worker w;
        
	CALL vn.timeControl_calculate(vDatedFrom, vDatedTo);

	DROP TEMPORARY TABLE tmp.`user`;
 
END$$
DELIMITER ;