G
Guest
Hi there,
I have a table that has the following layout:
Date EmployeeID SignIn SignOut
------------------------------------------------------
120204 123456 8:00 AM 9:00 AM
120204 123456 9:10 AM 11:00 AM
120204 123456 12:00 PM 5:00 PM
Notice we are looking at the same employee ID for a single date, and that an
employee may SignIn or SignOut multiple times during a given day.
Now, what I want to do is retrieve the earliest SignIn time and the latest
SignOut time to get the following result:
Date EmployeeID SignIn SignOut
I have a table that has the following layout:
Date EmployeeID SignIn SignOut
------------------------------------------------------
120204 123456 8:00 AM 9:00 AM
120204 123456 9:10 AM 11:00 AM
120204 123456 12:00 PM 5:00 PM
Notice we are looking at the same employee ID for a single date, and that an
employee may SignIn or SignOut multiple times during a given day.
Now, what I want to do is retrieve the earliest SignIn time and the latest
SignOut time to get the following result:
Date EmployeeID SignIn SignOut