restored the database and now can see the code for deleting:

       DELETE dbo.<table_name1> WITH (READPAST)
        FROM dbo.<table_name1> IPA
            JOIN dbo.[table_name2] AU WITH (NOLOCK) ON IPA.AuditID = AU.AuditID
            JOIN @RowsToBeDeleted...

Hi Jeff,

Thank you for the reply.

There are 2,875,436 rows to be deleted in Table , 2,780,000 rows were deleted in about...