I am using date table provided by Sam and is working as expected.
A Date table which start date is 01/01/ Minimum year from some table (say Sales Table) and end date is 12/31/ Maximum year from some table (Sales Table). When data in the table (Sales Table) changes, data in the Date table should be changed.
I tried example from some blogs, but those ideas are not easy as Sam’s Date table. What is the easiest way to make Sam’s Date table dynamic?