OR Just TRUNCATE the table before executing the statement

So you have a patient table with 9 diagnosis fields.
Just fill the 9 diagnosis fields with a union into a two field table (PatientID, DiagnosisID)
Make shure you...