|
|
dbWriter SQL DELETING ALL DUPLICATE RECORDS:
Here is a simple script that will clean up all duplicate records.
|
select distinct *
into #holding
from tbl_YourTable
truncate table tbl_YourTable
insert tbl_YourTable
select *
from #holding
drop table #holding
select count (*) from tbl_YourTable |
|
 |
