How to design a Calender table in Sql Server 2008 R2
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?