Attendance table in sql server 2005

My web application stores attendance of employees daily..

• How to design an attendance table in sql 开发者_StackOverflow社区server 2005?

I tried to figure it like this, Attendance table will contain columns EmpId,MonthId,1,2,3,4.....31..

• Is this ok enough to hold attendance?

Any suggestions....

Might be of your interest. Storing attendance records in the database

Depending on how you need to query the database, that approach could be the most efficient. However, I'd probably use the columns employee_id of integer, date of datetime.

While there would be many more rows this way, I think it makes a lot more sense.