About the Presentation
Identifying and Removing Duplicate Records
Perhaps you inherited a database with one or more tables having duplicate potential keys or maybe even entire duplicate records or maybe you generated a recordset from a SELECT statement that has duplicate records. In any case, you have a problem. You need to identify which tables have duplicate records or duplicate index values, isolate those records, and then delete only the duplicate records from the table. This session will focus on the functions and methods that you can use to identify and remove duplicate data from your tables
Session Level: Beginner
Michael Antonovich
Mike Antonovich is currently the Assistant Director of Web Services for Orange County Public Schools in Orlando, FL where he manages the SharePoint portal team implementing the Internet, intranet, collaboration, project, team, and school sites. He recently published his 6th book: Office and SharePoint 2007 User's Guide. Mike has been using SQL Server since 1998, and FoxPro for a dozen years before that. He has presented at SQL Saturday #1, #4, #8, #10, #15, and #16.
Contact URL:
http://www.micmin.org