I'm a little stuck with one table's design.
I have a table called tblConference_Board that will be updated approximately 3 to 4 times per year. The following is my table design:
CB_ID int (PK)
CB_Mnemonic_ID int (FK)
CB_Value decimal (18,10)
This table is loaded from a staging table called tblConference_Board_Staging.
When there is an update (say in the spring), the values will either be in quarters or annual values. The year range has been consistently the same and usually starts from 1961 to 2035. When the next update comes (in the summer), the yearly range will be the same but the actual values will change. What I'm stuck on is how to determine which data set is from which update? I thought that another field like maybe
CB_Modified date which would populate with the date that update takes place would be a good idea but that way may be tricky to query after the updates.
It's hard for me to summarize my question but it should be something like: How do I populate my table and know which values represent which update? I'm really hoping someone can make sense of my confusion and if you require more information please ask.