select distinct * into #temp from sc_infor truncate table sc_infor insert sc_infor select * from #temp drop table #temp