gary.morey (12/11/2013)
The SSN is stored as a MD5 hashed value.The combination of SSN, PKT and FICE_NBR in table A does not have a match on the combination of SSN, PKT and FICE_NBR in table B.
Ah, thanks, Gary. I feel much better now.
Shifting gears a bit, you might want to consider something a little bit more than simple MDF hashing. A simple billion row rainbow table (which is nothing on the machines today) would quickly unravel all of the SSNs. Even adding a salt to the MD5 would be better although that would likely still fail an audit.
--Jeff Moden
Change is inevitable... Change for the better is not.