salix/db/routines/vn/functions/time_getSalesYear.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` FUNCTION `vn`.`time_getSalesYear`(vMonth INT, vYear INT)
	RETURNS int(11)
	DETERMINISTIC
BEGIN
DECLARE vSalesYear INT;
SELECT salesYear INTO vSalesYear
FROM `time`
WHERE `month` = vMonth AND `year` = vYear
LIMIT 1;
RETURN vSalesYear;
END$$
DELIMITER ;