Custom Report: Customers - Duplicate

Report Description:
Generates a report showing potential duplicate customer records based on either:

Identical Birthday+First Name+Last Name


Identical Birthday+First Initial+Last Name+Zip Code.


Columns Displayed:

  • Last name
  • First name
  • Birthdate
  • Address
  • City
  • State
  • Zip code
  • Email
  • Customer type
  • Current status
  • Last visit date
  • ID card #



Download the SQL code as a .txt file


Disclaimer: Custom SQL reports can be used or modified by RGP customers at their own discretion. However, due to the custom nature of each report and the varying size of a customer's database, some reports may be slow to run (or may not run at all).  All support and/or modifications requested of these public, custom reports will follow the standard Custom SQL Report fee structure.

Please also see: Adding Custom SQL Reports

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.