Anyone who has experienced the import capabilities of Microsoft Dynamics CRM prior to the latest release (2011) will undoubtedly agree that they were not only sub-par but for the most part extremely frustrating and almost unusable. With the latest release, the out of the box import wizard has been improved quite substantially, allowing the ability [...]
continue reading...Posts Tagged ‘CRM Data Import’
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 [...]
continue reading...
