SELECT pAdmit_Svcs.AutoAdmitSvcs_ID, pAdmit_Svcs.Skill, IFNULL(TRIM(pAdmit_Svcs.Notes), '') AS Notes, pAdmit_Svcs.Start_Date FROM #Request.prefix_db_agency#.pAdmit_Svcs WHERE pAdmit_Svcs.Admit_ID = AND pAdmit_Svcs.Patient_ID = AND pAdmit_Svcs.Status = 0 AND pAdmit_Svcs.Skill NOT IN ('PT FU Eval', 'OT FU Eval', '0', '9 - Discharge from agency') ORDER BY pAdmit_Svcs.Start_Date, pAdmit_Svcs.AutoAdmitSvcs_ID SELECT pAdmit_Svcs_Procs.Admit_Svcs_ID, IFNULL(TRIM(MAX(pPathway.Description)), '') AS Proc_Description, pAdmit_Svcs_Procs.Item_ID FROM #Request.prefix_db_agency#.pAdmit_Svcs_Procs JOIN #Request.prefix_db_lookup#.pPathway ON pPathway.Item_ID = pAdmit_Svcs_Procs.Item_ID WHERE pAdmit_Svcs_Procs.Status = 0 AND pAdmit_Svcs_Procs.Admit_ID = AND TRIM(IFNULL(pPathway.Description, '')) <> '' GROUP BY pAdmit_Svcs_Procs.Admit_Svcs_ID, pAdmit_Svcs_Procs.Item_ID ORDER BY pAdmit_Svcs_Procs.Admit_Svcs_ID, Proc_Description