b1nary0mega
5/3/2016 - 1:23 PM

Find all duplicate entries that may be blocking query due to Primary Key (PK) violation

Find all duplicate entries that may be blocking query due to Primary Key (PK) violation

GetDuplicatePKEntries.sql
content_copyfile_download
select employee_id, end_dttm, count(*)
  from employee_times
 group by employee_id, end_dttm
having count(*) > 1;