You can do some thing like this

select * into TempTable

from OldTable

-- Here you can use a where condition to get only the records you wanted.

--or you can delete the records in the TempTable

DROP TABLE OldTable

EXEC sp_rename 'TempTable','OldTable'

This will get your table back with the columns you want