OFF DAYS

[immad]

sir

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 data does not 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 suggestion 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 aslo make a table name calendar and insert 2013 year dates in this table

this is my structure

CREATE TABLE [dbo].[Calendar]
(
[Date] [datetime] NULL
)

i want to show offday dates in database like this


date----------------------------eid----shift--------timein---------------------timeout--
2013-05-04 00:00:00.000--17031----G----2013-06-13 09:15:00.000-----2013-06-13 15:23:00.000
2013-05-04 00:00:00.000--17031----O-----------NULL------------------------NULL

i hope u under stand.i am in big problem
Thank in advance