I know how to create and insert a Dim Date table into my SSMS database.
However, I want to then update this table every night at 00:01 hours to reflect the new day.
let me keep it simple.
Let's say I have two columns only. One with the date in yyymmdd format and then another column which has a 1 if it is the current day and 0 otherwise.
Obviously, this second column, let's call it "IsCurrentDay", needs to be updated every day to reflect the new day.
Can anyone please me regarding this?