Home Forums SQL Server 2008 T-SQL (SS2K8) List out rows from a duplicate record set that has one or more odd values RE: List out rows from a duplicate record set that has one or more odd values

  • Geoff5,

    Thanks a lot for your suggested solution. I appreciate that.

    Eugene Elutin,

    Your solution looks simpler, but it is not sorting the end result the way I want it. Any suggestions on that?

    Sean Lange,

    Thanks for the encryption suggestion. This was just a sample data set I created to simulate my requirement. Actual data does not have any data as confidential as SSN. I definitely appreciate your suggestion and keep that in mind when I deal with any sensitive data.

    - Rex