>>select top (100) * into #SaveResults from TableToClean order by SomeColumn >>truncate table TableToClean >>insert into TableToClean >>select * from #SaveResults >>drop table #SaveResults