Need attendance table using stored procedures

See more:

SQL

Hi,

I am having table with two columns like this

eid    date
-----------
01     04/12/09
02     03/04/09

Now I need output like this

eid    1    2   3   4  5   6  7   8 ----------  31

01     a    a   a   p  a   a  a   a             a 

02     p    p   p   p

I need to use stored procedures and have to give parameter of empid there in stored procedure

Then if I give empid I have to get present or absent of that day in a month.