I am in the process of re-developing a page uisng asp.net that will pull in the content dynamically for a simple company holiday closure page:
My question is regarding handling the date fields in the db table creation.
Initially, I'm thinking the table structure should be as follows:
CREATE Table customer_service_closure_d
closure_Id int IDENTITY (1,1) PRIMARY KEY,
holiday varchar(50) NOT NULL
begin_date datetime NOT NULL
end_date datetime NOT NULL
I am going to create to an admin page so a service manager can update the closure dates as needed. However, I started thinking there might be a better way to automate the closures dates within SQL Server using the date functions?? So, when the new year arrives, the closure dates are automatically calculated and populated? The admin page could still have override capability if necessary. I was just trying to think if there was a more efficient way to automate how the closure dates are populated each year?
Maybe someone has done something similar and has some recommendations.
Any suggestions would be appreciated.