Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    4

    Unanswered: Get Time defaulters list

    Following are the table details
    1.
    name: time_tbl
    columns:
    time_id
    employee_id
    time_date (date)
    time_start(time)
    time_end(time)
    time_details(text)

    2.
    name: employee_tbl
    columns:
    employee_id
    employee_name(varchar)
    employee_join_date(datetime)

    Everyday employees enter their time entries and their task details. I want to have list of employees that did not fill their time entries between a given date range.

    If the date range is more than one day and the employee has not entered time details for more than one day in between the range, then the employee name should appear more than once with respect to date.

    Required output

    date | employee_id | employee_name

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You want to see where time_date is not adjacent to another date?

    Got sample data and what you expect to see?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •