sql server 2008 - Putting an individuals distinct diagnosis into one horizontal row AND excluding a specific diagnosis -

i working same query explained in question: diagnosis in 1 horizontal row. diagnosis data horizontal , want exclude active dementia (diagnosis status indicated each diagnosis). max # of diagnoses per person 50 have search each of 50 icd9 code fields each of 18 different icd9 codes (indicating dementia). have declared each of 18 codes @icd9code49 - @icd9code66, cannot figure out how exclude these data set. have tried following (problemstatus diagnosis status):

select * diagnosis ( ([problemstatus_1] = @problemstatus , (icd9code_1 <> @icd9code49 or icd9code_1 <> @icd9code50 or icd9code_1 <> @icd9code51 or icd9code_1 <> @icd9code52 or icd9code_1 <> @icd9code53 or icd9code_1 <> @icd9code54 or icd9code_1 <> @icd9code55 or icd9code_1 <> @icd9code56 or icd9code_1 <> @icd9code57 or icd9code_1 <> @icd9code58 or icd9code_1 <> @icd9code59 or icd9code_1 <> @icd9code60 or icd9code_1 <> @icd9code61 or icd9code_1 <> @icd9code62 or icd9code_1 <> @icd9code63 or icd9code_1 <> @icd9code64 or icd9code_1 <> @icd9code65 or icd9code_1 <> @icd9code66)) , ([problemstatus_2] = @problemstatus , (icd9code_2 <> @icd9code49 or icd9code_2 <> @icd9code50 or icd9code_2 <> @icd9code51 or icd9code_2 <> @icd9code52 or icd9code_2 <> @icd9code53 or icd9code_2 <> @icd9code54 or icd9code_2 <> @icd9code55 or icd9code_2 <> @icd9code56 or icd9code_2 <> @icd9code57 or icd9code_2 <> @icd9code58 or icd9code_2 <> @icd9code59 or icd9code_2 <> @icd9code60 or icd9code_2 <> @icd9code61 or icd9code_2 <> @icd9code62 or icd9code_2 <> @icd9code63 or icd9code_2 <> @icd9code64 or icd9code_2 <> @icd9code65 or icd9code_2 <> @icd9code66)) , ([problemstatus_3] = @problemstatus , (icd9code_3 <> @icd9code49 or icd9code_3 <> @icd9code50 or icd9code_3 <> @icd9code51 or icd9code_3 <> @icd9code52 or icd9code_3 <> @icd9code53 or icd9code_3 <> @icd9code54 or icd9code_3 <> @icd9code55 or icd9code_3 <> @icd9code56 or icd9code_3 <> @icd9code57 or icd9code_3 <> @icd9code58 or icd9code_3 <> @icd9code59 or icd9code_3 <> @icd9code60 or icd9code_3 <> @icd9code61 or icd9code_3 <> @icd9code62 or icd9code_3 <> @icd9code63 or icd9code_3 <> @icd9code64 or icd9code_3 <> @icd9code65 or icd9code_3 <> @icd9code66)) ) 

i've tried various combinations of and's , or's doesn't seem working.

this great time not in:

with dementiacodes (     select @icd9code49 code     union select @icd9code50     union select @icd9code51     ... ) select * diagnosis not ((problemstatus_1 = @problemstatus , icd9code_1 in (select code dementiacodes))     or (problemstatus_2 = @problemstatus , icd9code_2 in (select code dementiacodes))     or (problemstatus_3 = @problemstatus , icd9code_3 in (select code dementiacodes)))