UPDATE #Request.prefix_db_lookup#.Employee SET Password = '#trim(form.Password)#', Authority_Level = #form.Authority_Level#, Record_Mod_Date = #CreateODBCDateTime(Now())#, Record_Mod_By = #Session.EmployeeID#, ScheduleEdit = #scheduleEdit# WHERE Employee_ID = #form.EmpID# UPDATE #Request.prefix_db_lookup#.Employee SET Password = '#trim(form.Password)#', Record_Mod_Date = #CreateODBCDateTime(Now())#, Record_Mod_By = #Session.EmployeeID#, ScheduleEdit = #scheduleEdit# WHERE Employee_ID = #form.EmpID# Delete from #Request.prefix_db_agency#.employee_auth where eaID = #form.empID#; insert into #Request.prefix_db_agency#.employee_auth ( eaID, eaRole, eaSetSchedule, eaPayroll,eaBilling, eaOrders,eaAuthorizations, eaDataTransmit,eaType,eaCareplan, eaLock,eaSchedule, eaSetCareplanItems,eaSetCommSubjects, eaSetEmployees,eaSetIncidentSubjects, eaSetPayers,eaSetPayrollCodes, eaSetPhysicians,eaSetReferralSrcs, eaSetRevenueCodes,eaSetSupplies, eaSetAgyInfoUpdate,eaClientEdit, eaNoteEdit,eaUndo, eaReports,eaStatistics, eaPatientSurvey) values( , '', , 0, 0, 0, 0, 0, 0, 0, 0, , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); SELECT e.Employee_ID,a.AgencyType, e.skill from #Request.prefix_db_lookup#.Employee as e Left outer join #Request.prefix_db_lookup#.Agency as a ON e.Agency_ID=a.Agency_ID WHERE e.Employee_ID=#form.EmpID#; Level #Level# form.EmpID #form.EmpID# UPDATE #Request.prefix_db_lookup#.Employee SET Employee.Level='#Level#' where Employee_ID =#form.EmpID#;