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.