I would like to create a calendar from a history table for a customer, so that I can read the status for each day.
But I only have a history table where I can find dates of changes.
SupportlevelID | date | CostumerID
4 | 2019-12-05 14:05:41.540 | 36289
4 | 2019-12-12 11:43:25.350 | 36289
NULL | 2019-12-30 14:23:48.070 | 36289
NULL | 2020-06-05 15:30:01.147 | 36289?
So, the date when the level 4 is ending is the 2019-12-29 and the begining of the Level NULL is the 30th.
I habe the calendertable to join it, but do not come up with the solution.
Thank for help