can anyone give me a query ,its very urgent.

I have a table like this


sid intime outtime attendance
1 14/4/2010 10oAM 14/4/2010 5:00PM 1
1 15/4/2010 9:00AM 15/4/2010 5:00PM 1
1 16/4/2010 9:00AM 16/4/2010 6:00PM 1


i want output like this

sid monday tuesday wednesday thursday friday saturday sunday present Leaves

1 A A P p 2 2