#attributes.action#
#attributes.visitdate#
#attributes.employeeid#
#attributes.id#
select Agency.telephony_agencynumber,Employee.telephony_employeenumber from #Request.prefix_db_lookup#.Employee left outer join #Request.prefix_db_lookup#.Agency on Employee.Agency_ID = Agency.Agency_ID where employee_id = #attributes.employeeid# SELECT MAX(Telephony_ItemNumber) as maxnum from #Request.prefix_db_agency#.ScheduleItems where agency_id = #session.agencyid# and employee_id = #attributes.employeeid# and visit_date >= '#dateformat(startdate,"YYYY-MM-DD")#' and visit_date <= '#dateformat(enddate,"YYYY-MM-DD")#' Update #Request.prefix_db_agency#.ScheduleItems set Telephony_ItemNumber = #nextnum# where scheduleitems_id = #attributes.id#