We are seeing lot of duplicate records for sequence type 4,5,6 in PerioMeasure table, below is the query we are running to check the data.
Code: Select all
select SequenceType , IntTooth , PerioExamNum from perioMeasure group by SequenceType , IntTooth , PerioExamNum having count(*) > 1;
Thanks.