• You could add a checksum column on to apply to the columns wher you think the changes may occur. This will identify your row Id's that are out of sync. It is not a perfect application

    http://www.sqlservercentral.com/Forums/Topic776261-148-1.aspx

    From there it is just a matter of writing some code to get the data in the format you want, maybe using a table variable to hold the two different values with the same ID.

    ----------------------------------------------------