Post reply

Employee Roster

  • 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

  • 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]

  • 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)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply