Anyone have any good ideas about how to capture changes over time? I have a table that has attributes that I need to be able to retrieve what the values were at specified dates in the past.
Is the only way to do this by use of an additional table with an ‘Effective From’ date or does someone know of a better way to do it?
