SELECT Admit_ID, LEFT(F26, 1) AS ReasonDigit, UCase(Trim(IFNULL(F27, ''))) AS OrderSkill FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = ORDER BY CASE WHEN status = 0 THEN 0 ELSE 1 END LIMIT 1 SELECT Assmt_ID, F27 AS Skill, IFNULL(TRIM(F175), '') AS Narrative, F26 FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND status = 0 AND (F26 NOT LIKE '9%' AND F26 NOT LIKE '7%' AND F26 NOT LIKE '8%' AND F26 NOT LIKE '6%') AND TRIM(IFNULL(F175, '')) <> '' AND ( Assmt_ID = OR ( LEFT(F26, 1) = AND Assmt_ID <= ) OR ( F27 IN ('PT', 'OT', 'ST') AND ( F26 LIKE '%Evaluation%' OR LEFT(F26, 1) = ) ) ) ORDER BY F27, CASE WHEN Assmt_ID = THEN 0 ELSE 1 END, CASE WHEN <> '' AND LEFT(F26, 1) = THEN 0 ELSE 1 END, Assmt_ID DESC ]*>", "", "all") /> ", "all") /> SELECT Assmt_ID, UCase(Trim(IFNULL(F27, ''))) AS Skill, F26 FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND status = 0 AND F27 IN ('PT', 'OT', 'ST') AND F26 LIKE '%Evaluation%' ORDER BY CASE WHEN TRIM(IFNULL(F175, '')) <> '' THEN 0 ELSE 1 END, Assmt_ID DESC SELECT TRIM(s.Notes) AS Notes, IFNULL(s.Skill, '') AS Skill, IFNULL(s.Visit_Type, '') AS Visit_Type, IFNULL(r.HCPCS, '') AS HCPCS FROM #Request.prefix_db_agency#.pSchedules s INNER JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = s.Assmt_ID AND a.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pRevenue_Code r ON r.Rev_CodeID = s.HCPCS_ID AND r.Status = 0 WHERE a.Admit_ID = AND s.Status = 0 AND CHAR_LENGTH(TRIM(IFNULL(s.Notes, ''))) >= 40 ORDER BY CHAR_LENGTH(TRIM(s.Notes)) DESC