Does anyone know of a means to compare two records, in toto, for equality||inequality? The records have exactly the same structure, including column names and PK, and have a 1:1 relationship. One record comes from a local table and represents the data as it was at its original INSERTion or most recent UPDATE. The other record is in a view, populated by the data as it currently exists in a production database. It might or might not have changed since the most recent refresh of the local data. I would like to find a way to take a "management by exception" approach to by means of a record-by-record comparison between the pair of records. Then, if there is a difference, dig into the nature of the inequality. IOW, for any PK, is #RecordInLocalTable = #RecordInProductionView? If equal, get next PK-matched pair of records. If not, then lather, rinse, repeat. Thanks, Steve in Memphis
