Custom Report: Customers - Duplicate

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

Identical Birthday+First Name+Last Name

OR

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 #

Customer---Duplicates2.png

 

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?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.