CREATE TABLE #Temp

(

AutoId int,

EmpId int,

TimeIn datetime,

TimeOut datetime

)

INSERT #Temp (AutoId, EmpId, TimeIn, TimeOut) VALUES (1, 1009, '10-13-2012 22:10', '10-13-2012 22:15');

INSERT #Temp (AutoId, EmpId, TimeIn, TimeOut) VALUES (2, 1009, '10-13-2012 22:20', '10-13-2012 22:32');

INSERT #Temp (AutoId, EmpId, TimeIn, TimeOut) VALUES (3, 1009, '10-13-2012 22:34', '10-13-2012 22:36');

SELECT * FROM #Temp

;WITH CTE AS

(

SELECT T.EmpId, T.TimeIn, T.TimeOut, ROW_NUMBER() OVER(ORDER BY T.TimeIn, T.TimeOut ) AS row_num

FROM #Temp AS T

)

SELECT N.EmpId, p.TimeIn, p.TIMEOUT, n.TimeIn, DATEDIFF(MI, p.TimeOut, n.TimeIn)

FROM CTE AS N

INNER JOIN

CTE AS P

ON P.row_num = N.row_num - 1;

DROP TABLE #Temp