question

jodyamorgan avatar image
jodyamorgan asked

Convert Audit Log to Historical rows

I have a log table for tracking changes in the DB. For each column it creates a record for that column with old and new value and other necessary parameters to identify the changed record along with who and when. I want to convert that data to a historical result set for the record as a whole by time stamp. Below is an example. ![alt text][1] The order table may look like this for the current record status for the record. ![alt text][2] Any help is appreciated [1]: /storage/temp/3058-capture1.png [2]: /storage/temp/3060-capture3.png
pivotconvertrow-comparisondenormalize
capture1.png (9.0 KiB)
capture3.png (12.1 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.