create constant unique ID from three columns
Posted on 2014-02-07
I have a large contact table that gets refreshed every quarter. I am trying to assign a unique identifier to the field that, unlike newid(), will remain constant with updates. I know I can build a string from things like firstname, lastname, address,city, state, zip, but what would be the best way to convert that string concatenation into an identifier that will be constant with every update (I know when people move it will change the id, but that is not of concern for me right now).
Thanks for the help.