By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| ID | Date | Value | Period |
|---|---|---|---|
| 1 | 1990-05-17 00:00:00.000 | 1.0 | 1 |
| 1 | 1991-10-12 00:00:00.000 | 1.0 | 1 |
| 1 | 1992-08-01 00:00:00.000 | 1.0 | 1 |
| 1 | 1993-07-05 00:00:00.000 | 0.7 | 2 |
| 1 | 1994-05-02 00:00:00.000 | 0.7 | 2 |
| 1 | 1995-02-01 00:00:00.000 | 1.0 | 3 |
| 1 | 1996-03-01 00:00:00.000 | 1.0 | 3 |