That was my fear. Thanks for your help.

Each patient can only have 9 diagnosis. The table is structured like I this.
Admission.Diagnosis9_1 to Admission.Diagnosis9_9
I cannot make changes to any structures, just hoping someone may have an idea.

Unfortunately, I cannot make changes to the database. We did not develop it.

SELECT   dbo.mdhomadm.Patient_Number, dbo.mdhomadm.Diagnosis9_1, dbo.mdhomadm.Diagnosis9_2, dbo.mdhomadm.Diagnosis9_3, dbo.mdhomadm.Diagnosis9_4, dbo.mdhomadm.Diagnosis9_5,
         dbo.mdhomadm.Diagnosis9_6, dbo.mdhomadm.Diagnosis9_7, dbo.mdhomadm.Diagnosis9_8, dbo.mdhomadm.Diagnosis9_9, dbo.mdicdcde.ICD_Code_Description
FROM    dbo.mdhomadm LEFT OUTER JOIN
         dbo.mdicdcde ON dbo.mdhomadm.Diagnosis9_1 = dbo.mdicdcde.ICD_Code

Each patient may have...

You Rock!!

Thank you for your help. I had to tweak it a little in order to get the minutes but just getting the first part was tremendously helpful.

Thanks again,

Doug