Try this script in Query analyser

BEGIN TRANSACTION T1

SELECT DISTINCT * INTO TempTable FROM MainTable GROUP BY SSN HAVING COUNT(*) > 1

DELETE MainTable WHERE SSN IN (SELECT SSN From TempTable)

INSERT INTO...

Good introduction for me about SQL Server.  The article gives me a footstep for me to SQL Server 2005.  SHORT and SWEET.

SELECT * FROM Orders WHERE OrderID IN (4+1, 4-1)