Sy-1148362 (11/30/2013)
Hi There!I have an Employee table with Columns:
EmpID | FirstName | MiddleName | LastName | SSN | BirthDate | HireDate | City | Zip
Requirement: I have to identify the duplicate records based on below criteria:
Criteria1: SSN
Criteria2: FirstName, LastName, BirthDate
Criteria2: FirstName, LastName, City, Zip
Please tell how to accomplish this task........Thanks in Advance
You'll get much more help if you show what you've tried.
--Jeff Moden
Change is inevitable... Change for the better is not.