SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#session.cs.AssessmentId#'
select Diagnosis_ID,Diagnosis,ICD,CONVERT(Diagnosis.Dx_Order, CHAR(10)) as Dx_Order from #Request.prefix_db_agency#.Diagnosis where Assessment_ID='#session.cs.AssessmentId#' and M0190_Link LIKE '%#M0190#%' and M0190_Link is not null
ORDER BY Diagnosis.Dx_Order asc
select Diagnosis_ID,Diagnosis,ICD,CONVERT(Diagnosis.Dx_Order, CHAR(10)) as Dx_Order from #Request.prefix_db_agency#.Diagnosis where Assessment_ID='#session.cs.AssessmentId#' and M0190_Link LIKE '%#M0190#%' and M0190_Link is not null and ICD10 <> 1
ORDER BY Diagnosis.Dx_Order asc
Name
Location
Action
#M1010diagnasis.ICD#
#Left(M1010diagnasis.Diagnosis, 55)#
Session is Null Please Close the Browser and Login Again