Common          EmployeeHoliday;
DictTable       dictTable;
SQLDICTIONARY   SqlDictionary;
int             FromDate, ToDate;

select tabId from SqlDictionary
    where SqlDictionary.name == "NW_UpdateEmployeeHoliday"
    && SqlDictionary.fieldId == 0;

dictTable = new DictTable(SqlDictionary.tabId);
EmployeeHoliday = dictTable.makeRecord();

FromDate = fieldname2id(SqlDictionary.tabId,"FromDate");
ToDate   = fieldname2id(SqlDictionary.tabId,"ToDate");
date holiday, endHoliday;
end =  start+180;
while select EmployeeHoliday
{
    holiday = EmployeeHoliday.(FromDate);
    endHoliday = EmployeeHoliday.(ToDate);
    while(holiday <= endHoliday && (start <= holiday && holiday <= end))
    {
        holiday+=1;
        end+=1;
    }
}