DELETE FROM #Request.prefix_db_agency#.pVisit_Compliance WHERE Auth_ID = SELECT * FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID WHERE pAuths.Auth_ID = AND pAuths.Patient_ID = AND pAuths.Status = 0 AND pAssessments.Status = 0 GROUP BY Auth_ID SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Auth_ID = AND Patient_ID = AND pSchedules.Status = 0 GROUP BY Schedule_ID SELECT * FROM getschedules WHERE Visit_Date BETWEEN '#Request.Date_Start#' AND '#Request.Date_End#' AND prn_visit !=1 INSERT INTO #Request.prefix_db_agency#.pVisit_Compliance ( Auth_ID, Week_No, Date_Start, Date_End, Visit_No, PRN, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , ) SELECT * FROM getschedules WHERE Visit_Date BETWEEN '#getauths.F177#' AND '#getauths.F178#' AND prn_visit =1 INSERT INTO #Request.prefix_db_agency#.pVisit_Compliance ( Auth_ID, Week_No, Date_Start, Date_End, Visit_No, PRN, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , )