DB Design - date sensitive changes - TechRepublic
General discussion
September 26, 2001 at 12:15 PM
kdowson

DB Design – date sensitive changes

by kdowson . Updated 24 years, 9 months ago

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?

This discussion is locked

All Comments