How to design a Calender table in Sql Server 2008 R2

Oct 29 2015 1:39 AM

How to design a Calender table in Sql Server 2008 R2?. Like if we have calender table than i can store the working days,leave days,Holidays, weekends. Is that possible to design all these in one table?. Or do i need a master and transaction tables?

Answers (1)

compare two date from two table in sqlserver

sql query execution using exists and IN