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 Diagnosis.Assessment_ID='#session.cs.AssessmentId#' AND patient_ID = '#session.cs.patientid#' and M0210_Link LIKE '%#M1016#%' and M0210_Link is not null AND Disabled <> 1 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 Diagnosis.Assessment_ID='#session.cs.AssessmentId#' AND patient_ID = '#session.cs.patientid#' and M0210_Link LIKE '%#M1016#%' and M0210_Link is not null AND Disabled <> 1 ORDER BY Diagnosis.Dx_Order asc

#(M1016diagnasis.ICD)#

#Left(M1016diagnasis.Diagnosis,40)#

SELECTED>1 SELECTED>2 SELECTED>3 SELECTED>4 SELECTED>5 SELECTED>6