Scott's suggestion looks good.

What I was looking for, and I am probably not drawing a decent picture, is a way to get a value out of multiple columns so that I will have a distinct value for each field and if I have to reload the data, the values will not change.

What I started playing with is concatenating the four columns and converting them to varbinary and then converting that to varchar(36) with style 2.

I'm at home now so I don't have the script I was working with. I'll update the post tomorrow with what I wrote.

Anways, That gives me a value that is based off of the four columns. I was able to do it on the 1.8 million record table I was working with and then assigned that column as the PK. I did not have any PK violations, so I am getting a unique value. I still have some more playing around with it to see if this method is of any value.