hi guys, i am currently creating a sql select statement for my project. The project would create a log data every minute if the user is away from the work station, thus the log would pretty much look like

Name DateTime
Alvin 11/09/08 11:30:00AM
Alvin 11/09/08 11:31:00AM
Alvin 11/09/08 11:32:00AM
Alvin 11/09/08 03:24:00AM
Alvin 11/09/08 03:25:00AM

I would need a select statement which...