var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: duplicates in a table
Select count (*) from tower.nbdocdeletedrecords
Where scandate = '12/13/2008'
and slevel = 6
Returns 5798 records
select distinct towid from tower.NBdocdeletedrecords where slevel=6 and scandate = '12/13/2008' and username = 'SQLKofc'
returns 2899 records which is correct
How do I delete the duplicates???
What version of SQL Server?
SQL Server 2000 SP4 Enterprise Edition
You have different criteria in your WHERE clauses. That may be a large part of your problem.