SQL Server Performance

Help!! with Transact SQL

Discussion in 'General Developer Questions' started by LucasDa, Sep 25, 2008.

  1. LucasDa New Member

    Hi!!, My name is Lucas and I have trouble with 3 points from a test.
    The problems are:

    1- Get all employees who worked every day from 01-05-2006 to 10-05-2006 (dd-mm-yyyy) and not worked since the day 11-05-2006 until 20-05-2006 day ( dd-mm-yyyy).

    2- Get the total number of hours worked per employee for the month of May 2006, considering only those employees supervised by Pedro.

    3- Get the total number of hours worked per employee in 2006.

    For this I have two tables Employees_1 a call and another call Employees_2.
    In Table Employees_1 I have three columns employee_id, Name_Employe, Surname_Employee.
    In Table Employees_2 I have thre columns employee_id, Start_Date, End_Date (In the columns Star_Date and End_Date I have such data as "01-05-2006 10:12:00 // "01-05-2006 18:00:00"").
    I need help, I do not know how to solve these problems.
    Thanks!!!!
  2. FrankKalis Moderator

    Sorry, but if we answer these questions, this might help you with your test, but you really gain nothing in the end.
  3. preethi Member

    Please Read SELECT statement in BOL. It will help you to understand the logic behind. If we give you the answer, we (including you) might be guilty of "Impersonation" or some thing equal to that.

Share This Page