I have a source table that contains Employee IDs and names. The employee names may be listed multiple times with variations on the exact spelling (see 'source table' for example - note the middle initial is sometimes present).
I want to insert unique values, in alphabetical order, into a new table (see 'target table' for desired results). I don't care which version of someone's name is inserted into my target table...what I want is one truly distinct value per person in my target table sorted alphabetically by last name.
Emp_ID Name 123 Jones, John 123 Jones, John P 123 Jones, John P. 456 Lewis, Jerry 456 Lewis, Jerry L 456 Lewis, Jerry L. 789 Hewitt, Jennifer 789 Hewitt, Jennifer L
Target table (desired results):
Emp_ID Name 789 Hewitt, Jennifer 123 Jones, John 456 Lewis, Jerry L