ALTER FUNCTION "DBA"."F_AddNBankDays"( IN dbegin date, in ndays integer )
RETURNS date
DETERMINISTIC
BEGIN
DECLARE cdateret date;
DECLARE i integer;
DECLARE n integer;
DECLARE cn integer;

SET cdateret = dbegin;
SET n = 0;

lbl:
LOOP
SET cdateret = dateadd(day,1,cdateret);
IF DATEPART(weekday,cdateret) not in (1,7) THEN
// если рабочий день, то проверяем или наша любимая страна мож сделала его віходнім
SET cn = 0;
SELECT count(*)
INTO cn
FROM "dba"."holiday_days"
WHERE ( "dba"."holiday_days"."cdate" = cdateret ) AND
( "dba"."holiday_days"."ctype" = 1 );
IF cn = 0 THEN //рабочий
SET n = n + 1;
END IF;
ELSE //суббота или воскресенье, но в нашей стране могет и рабочий быть
SET cn = 0;
SELECT count(*)
INTO cn
FROM "dba"."holiday_days"
WHERE ( "dba"."holiday_days"."cdate" = cdateret ) AND
( "dba"."holiday_days"."ctype" = 2 );
IF cn > 0 THEN //рабочий
SET n = n + 1;
END IF;
END IF;

IF n = ndays THEN
LEAVE lbl;
END IF;

END LOOP lbl;


/* Type the function statements here */
RETURN cdateret;
END