Forum Discussion
Temporal Table - Change the ValidFrom Time
Sql Server 2022 - We needed a new 'Bonus' value to be active from 11/01/2025 06:00:00. I created a one time SQL job to update the temporal table for the Bonus value (going from 2.175 to 2.00) to run ...
Thanks for the update. I think what Temporal tables were in the beginning were what I was looking for, but I have a better understanding about its limitations and what it would be more practical for. I had Copilot create a set of tables and triggers that would 'emulate' what I was looking for with Temporal tables. With that settled, this inquiry can be closed.