Posts Tagged ‘Data Clensing’

Hitachi Solutions America, Ltd.'s Logo More Duplicate Data Cleanup for Importing to CRM: ROW_NUMBER

Jeff Trantham’s blog on this subject has inspired me to share my just about, all-time-favorite duplicate detection tool in SQL.  It’s the ROW_NUMBER() function and I like to consider it my first line of defense in preventing duplicates from winding their way into the CRM.  As Jeff mentioned, there are many tools in SQL to …

More Duplicate Data Cleanup for Importing to CRM: ROW_NUMBER Read More »

 

Show Buttons
Hide Buttons