SELECT * FROM #Request.prefix_db_agency#.pAdmit WHERE pAdmit.Patient_ID = AND pAdmit.Status = 0 ORDER BY M0030_START_CARE_DT DESC SELECT pSchedules.*,pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Status = 0 AND pAssessments.Assmt_ID = pSchedules.Assmt_ID JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Status = 0 AND pAuths.Assmt_ID = pAssessments.Assmt_ID JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Status = 0 AND pAdmit.Admit_ID = pAssessments.Admit_ID WHERE pSchedules.status = AND pSchedules.Patient_ID = AND pSchedules.Missed = 0 AND pAdmit.Admit_ID = GROUP BY pSchedules.Schedule_ID ORDER BY pAssessments.Patient_ID ASC,pAdmit.Admit_ID ASC, pSchedules.Skill ASC, pSchedules.Visit_Date ASC, pSchedules.Schedule_ID ASC UPDATE #Request.prefix_db_agency#.pSchedules SET Visit_no = #i# WHERE Schedule_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.pSchedules SET Visit_no = 0 WHERE Schedule_ID = AND Status = 0 UPDATE #Request.prefix_db_agency#.pSchedules s JOIN #Request.prefix_db_agency#.pAssessments a ON a.Status = 0 AND a.Assmt_ID = s.Assmt_ID SET s.Visit_no = 0 WHERE s.Patient_ID = AND s.Status = 0 AND s.Missed = 1 AND a.Admit_ID =