SHOW OFF DAY

• immaduddinahmed

  Ten Centuries

  Points: 1375

  More actions

  June 15, 2013 at 1:55 am

  #148170

  HI

  i am making a attendance software and i want to show off days in my data

  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 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 data

  please give me a suggestion to look data 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

  5-May-2013--------------------------O----------------17090

  i hope u under stand

  Thanks in advance

  immad

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  June 16, 2013 at 8:49 am

  #1624440

  Duplicate post. Please direct all your replies here

  http://www.sqlservercentral.com/Forums/Topic1463838-391-1.aspx

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/