Hi

I am facing similar kind of problem . Please let me know if you came across any solution for this.

Thanks

If it is only about finding the count of duplicate records then this query would work.

CREATE TABLE #DuplicateRecordFinder(

[requestNumCer] [char](12) NOT NULL,

[suffix] [char](3) NOT NULL,

[AmountTypeCode] [char](2) NOT NULL,

[EffDate] [datetime2](3) NOT NULL,

[CreationDateTime]...

I wonder if MERGE statement can be used in this case. This script is only for [Changes] table . If it is performance effective we can implement the same...

I wonder if MERGE statement can be used in this case. would something like this improves the performance

Merge [dbo].[Changes] T1

using

[dbo].[Changes_DupCk] S

on

T1.requestnumber = S.requestnumber AND

T1.suffix = S.suffix AND

T1.AmountTypeCode = S.AmountTypeCode...