Same thing Using Join in CTE

declare @Checador TABLE (

i int identity (1,1),

TARJETA int,

HORA datetime,

FECHA date,

RELOJ int)

INSERT @Checador VALUES

(30 , '02/08/2010 08:14' , '02/08/2010' , 1 ),

(30 , '02/08/2010 12:57' , '02/08/2010' , 1 ),

(30 , '02/08/2010 14:01' , '02/08/2010' , 1 ),

(30 , '02/08/2010 19:21' , '02/08/2010' , 1 ),

(35 , '02/08/2010 07:23' , '02/08/2010' , 1 ),

(35 , '02/08/2010 13:05' , '02/08/2010' , 1 ),

(16 , '02/08/2010 12:58' , '02/08/2010' , 1 );

;with cte as

(

select ch.i,ch.TARJETA ,ch.HORA as HORA_INICIO ,ch1.HORA as HORA_TERMINO ,ch.FECHA ,ch.RELOJ

from @Checador ch

left join @Checador ch1

on ch.i+1=ch1.i

)

select TARJETA,HORA_INICIO,HORA_TERMINO,FECHA,RELOJ

from cte where i%2<>0