Something like this..

CREATE TABLE SSNTemp (

 SSN char (10) NOT NULL

)

CREATE UNIQUE

  INDEX [IX_SSNTemp] ON SSNTemp ([SSN])

WITH

    IGNORE_DUP_KEY

insert into SSNTemp

select ssn from yourssntable

delete from yourssntable

insert into yourssntable

select ssn from SSNTemp