For example, I have a table with a schema

CREATE TABLE #Test {

EmployeeID Int,

LogTime DateTime

}

INSERT INTO #Test

(1001, '01/01/2010 10:22:36'

1002, '01/01/2010 10:24:37'

1003, '01/01/2010 10:24:38'

1001, '01/01/2010 10:24:39'

1001, '01/01/2010 10:24:40'

1002,...