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
Diagnosis #
Diagnosis Desc
Dx Order
Action
#M1010diagnasis.ICD#
#Left(M1010diagnasis.Diagnosis,55)#
Session is Null Please Close the Browser and Login Again