BEGIN TRANSACTION tran_Individual_DuesCategory

UPDATE Individual
SET Individual.DuesCategoryID= DuesCategory.DuesCategoryID


where DuesCategoryID=DuesCategoryID
from DuesCategory where DuesCategoryName=@catcde
where DuesCategoryName= Conversion.Con_L00200_Loc.catcde
DuesCategoryID= case Conversion.Con_L00200_Loc.catcde
when 'Active' then 'Per Diem'
when 'Probation' then 'No Dues.'
when 'Full Dues' then 'Full Dues.'
when 'Special 1/2 Dues' then '1/2 Dues.'
when ' ' then null
END