Forum Discussion
Auto increment year value dynamically to multiple tables
Hello people, I am not sure this is the right approach or right question to ask. But i have a requirement to update (increment year value with 1 ex - 2023 to 2024) only date columns in all fac...
lbendlin
Super User
Super UserWhy do you need to add these years in the first place? Can't you leave your data as is and carry a reference table with the year offset for each table?