HI

i want to show off days in my report

my sql data is like this



date----------timein------timeout--shift----------eid
2-May-2013--9:20AM---6:17PM-----G-----------17090
3-May-2013--9:09AM---2:01PM-----G-----------17090
4-May-2013--9:03AM---10:41AM----G-----------17090



sql doesnot show 5 may data in sql or u can say sunday data becouse sunday is off and no employee come on sunday thats why i cant show off day in report

please give me a formula to look data like this
or any month when sunday come report show O in shift and show date just like below



date----------timein------timeout--shift----------eid
2-May-2013--9:20AM---6:17PM-----G-----------17090
3-May-2013--9:09AM---2:01PM-----G-----------17090
4-May-2013--9:03AM---10:41AM----G-----------17090
5-May-2013----------------------------O-----------17090


i hope u under stand
please help me out


Edited by immad - 13 Jun 2013 at 1:23am

your idea is good please brief me more what i understand is this i make a table and write all the date from 1/1/2013 to 1/31/2013 then what i do please help me out thanks