SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA select agency_id from #Request.prefix_db_lookup#.Agency where status='active' ORDER BY agency_id DELETE from #Request.prefix_db_lookup#.Schedules_Dup Update #Request.prefix_db_agency#.pSchedules SET Schedules_Dup = 0 WHERE status = 0 AND Year(pSchedules.Visit_Date) = YEAR(CURDATE()) AND MONTH(pSchedules.Visit_Date) = MONTH(CURDATE()) Insert IGNORE INTO #Request.prefix_db_lookup#.Schedules_Dup ( Schedule_ID,Patient_ID,Visit_Date,StartTime,EndTime,Emp_ID ) select Schedule_ID,Patient_ID,Visit_Date,StartTime,EndTime,pSchedules.Emp_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID WHERE pSchedules.status = 0 AND Year(pSchedules.Visit_Date) = YEAR(CURDATE()) -- AND MONTH(pSchedules.Visit_Date) = MONTH(CURDATE()) AND pSchedules.Visit_Date >= now() - INTERVAL 2 month and Schedules_Dup != 3 AND pEmployee.Loc_ID = #agencyList[2]# AND pEmployee.status = 0 Update #Request.prefix_db_agency#.pSchedules SET Schedules_Dup = 0 WHERE Schedules_Dup = 2 AND status = 0 Select * FROM #Request.prefix_db_lookup#.Schedules_Dup ORDER BY Emp_ID ASC SELECT s.Schedule_ID,s.Visit_Date,s.StartTime,s.EndTime FROM #Request.prefix_db_agency#.pSchedules s JOIN #Request.prefix_db_agency#.pPatients on s.Patient_ID = pPatients.Patient_ID AND pPatients.status = 0 WHERE s.Visit_Date = '#DateFormat(Visit_Date,"yyy-mm-dd")#' AND (time('#StartTime#') Between s.StartTime And s.EndTime OR time('#EndTime#') Between s.StartTime And s.EndTime OR s.StartTime Between time('#StartTime#') AND time('#EndTime#') OR s.EndTime Between time('#StartTime#') AND time('#EndTime#')) AND s.Emp_ID = #Emp_ID# AND s.status = 0 AND s.Missed = 0 Update #Request.prefix_db_agency#.pSchedules SET Schedules_Dup = 2 WHERE Schedule_ID in (#Schedule_ID#) DELETE from #Request.prefix_db_lookup#.Schedules_Dup