1

Topic: What it is better, to name initial and finite date, or the initial suffices?

Happens such that any value changes in due course.
For example, the hourly rate of payment. Or exchange rates.
As it is better, to specify initial and finite value of action of value, or to leave only the initial.
Then finite value settles up.

2

Re: What it is better, to name initial and finite date, or the initial suffices?

to;
You asked too philosophical question. So that the unambiguous answer on it is not present. But that you want - is called "slowly changing measurement" (Slowly Changing Dimensions). .
And you will be surprised, but just two main variants of its implementation are described in your question smile wink
For itself solve - as better. Or come here - we consider

3

Re: What it is better, to name initial and finite date, or the initial suffices?

to wrote:

Happens such that any value changes in due course.
For example, the hourly rate of payment. Or exchange rates.
As it is better, to specify initial and finite value of action of value, or to leave only the initial.
Then finite value settles up.

To SQL 2008 (can be even 2012) it was better to hold initial and finite.
But now with the advent of construction OUTER APPLY (SELECT TOP 1 FROM ORDER BY) it is possible to manage and one date.
Possible methods  the data are described here https://en.wikipedia.org/wiki/Slowly_changing_dimension