DELETE FROM #Request.prefix_db_agency#.pVisit_Compliance SELECT * FROM #Request.prefix_db_agency#.pAuths JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAuths.Patient_ID AND pPatients.Status = 0 WHERE pAuths.Status = 0 AND pAuths.Visitfreq_Placeholder = 0 AND pAssessments.Status = 0 AND pAssessments.Admit_ID IN ( SELECT pAdmit.Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE pAdmit.Status = 0) GROUP BY Auth_ID ORDER BY pAuths.Patient_ID, pAuths.Assmt_ID ASC SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE Auth_ID IN (#ValueList(getauths.Auth_ID)#) AND pSchedules.Status = 0 GROUP BY Schedule_ID SELECT * FROM getschedules WHERE Visit_Date >= '#Request.Date_Start#' AND Visit_Date <='#Request.Date_End#' AND prn_visit !=1 AND Auth_ID= #Request.Auth_ID# INSERT INTO #Request.prefix_db_agency#.pVisit_Compliance ( Auth_ID, Skill, Visit_ordered, Visit_Count, 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 '#Request.Cert_Start#' AND '#Request.Cert_End#' AND prn_visit =1 AND Auth_ID= #Request.Auth_ID# INSERT INTO #Request.prefix_db_agency#.pVisit_Compliance ( Auth_ID, Skill, Visit_ordered, Visit_Count, Week_No, Date_Start, Date_End, Visit_No, PRN, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , )