How can I do it through an Array? Or other efficient and simple way?

[katrina11]

Hi Experts,

I need to to calc the percentage of members who had different medicl conditions by ICD-9 codes. Not just by primary diagnosis but by five diagnosis as there are 5 diag for each patient in DW.

For ex I need ICD-9 214-215.99 for diag1,diag2, diag3, diag4, diag5
I believe it should be done through array to make it more simple. How to implement it in SQL SERVER 2005?

Could you please help me with code?

Any help would be greately appreciated.

Katrin

 

[simian336]

Could you provide a larger data sample and your expected results, to clarify what you are looking for.

Simi