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 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,Emp_ID FROM #Request.prefix_db_agency#.pSchedules WHERE 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 Select * FROM #Request.prefix_db_lookup#.Schedules_Dup ORDER BY Patient_ID ASC Update #Request.prefix_db_agency#.pSchedules SET Schedules_Dup = 0 WHERE Schedules_Dup = 1 AND status = 0 SELECT Schedule_ID,Visit_Date,StartTime,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.Patient_ID = #Patient_ID# AND s.status = 0 AND s.Missed = 0 Update #Request.prefix_db_agency#.pSchedules SET Schedules_Dup = 1 WHERE Schedule_ID in (#Schedule_ID#) DELETE from #Request.prefix_db_lookup#.Schedules_Dup