Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Name table Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 1:04 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:08 PM
Points: 365, Visits: 1,095
Hello, My search skills are poor at best, so I was not able to get very far. But I have a nice table of measurement conversions.

What I want is a table of common names so for a given name it will be matched to a standard name.

    Name Standard
    ------ -------
    Bill William
    Rich Richard
    Tony Anthony



Has anyone heard of something like this?

Thank you,
Post #1597463
Posted Tuesday, July 29, 2014 1:19 PM This worked for the OP Answer marked as solution


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:08 AM
Points: 1,510, Visits: 8,472
If you're looking for a list of names, Google: "nicknames and full names" and you'll find a few.

What you're trying to do is a simple use of a lookup table. It's a commonly used process, but maybe not for names.




Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #1597468
Posted Tuesday, July 29, 2014 1:24 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:08 PM
Points: 365, Visits: 1,095
Lookup table no problem. Been there done that.

I was looking for information to populate the lookup table.

Thanks for the nickname hint. One problem I have with internet searches is I tend to focus too tightly.
Post #1597473
Posted Wednesday, July 30, 2014 1:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:06 AM
Points: 227, Visits: 911
bear in mind that this is a many to many relashionship - in many cases but not all this will be resolved providing you know the sex of the individual.

e.g. Al could be Alexander, Alistair (and variants), Alan (and variants), Alfred, Alice, Allyssa, Alison
Post #1597607
Posted Wednesday, July 30, 2014 4:45 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:08 PM
Points: 365, Visits: 1,095
crmitchell (7/30/2014)
bear in mind that this is a many to many relashionship - in many cases but not all this will be resolved providing you know the sex of the individual.

e.g. Al could be Alexander, Alistair (and variants), Alan (and variants), Alfred, Alice, Allyssa, Alison

Thanks. This is just a check used for a fuzzy match of first name after SSN and last name are matched.
Post #1597640
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse