Employee Roster

• learnerbd

  SSC Rookie

  Points: 45

  More actions

  May 13, 2011 at 7:50 am

  #240326

  Dear All,

  If you have any employee Rostering Query from at least 3 Table (Employee,Attendance,Roster)

  Please help me

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  May 13, 2011 at 1:42 pm

  #1324545

  Without further information it is difficult to assist you. Please click on the first link in my signature block and learn how to post table definitions, some sample data, expected results ... so some one can assist you with a tested solution

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Jeff Moden

  SSC Guru

  Points: 1004641

  More actions

  May 13, 2011 at 4:51 pm

  #1324581

  learnerbd (5/13/2011)

  ---

  Dear All,

  If you have any employee Rostering Query from at least 3 Table (Employee,Attendance,Roster)

  Please help me

  Such example queries exist in the "AdventureWorks" example database that comes with SQL Server. Look there.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)