Last week I illustrated a snapshot technique to capture copies of data sets in the database associated with a specific transaction. Once we sorted out the stored procedure issue (needed to be closed) we have found that it works pretty well for capturing the state of a set of data in time.
The bigger problem now is how best to illustrate to a user in a report the differences between two complex sets of multiple rows that at times can have up to 100 individual columns and many rows
The goal here is to derive a report from two data stores which represent the same column set with data at different points of time. We have time stamps for added and changed to help.
My question is whether anyone already had developed routines for comparing these sets that can identify rows added or deleted from the original set in the newer set and can highlight columns that have been changed?
Were there any reporting styles which helped to make the differences stand out?
If you know of any routines in the pfc or other libraries, or even third party tools, please suggest.
I know I can probably knock this out, but hate to do this if it had already been done before.