declare @tabla table
(
placa nvarchar(30) ,
hora time ,
vuelta int
);
insert into @tabla
( placa, hora, vuelta )
values
( N'A4S879', '10:50', 1 ),
( N'A8R559', '10:50', 1 ),
( N'A8R559', '12:50', 2 ),
( N'A4S879', '12:50', 2 ),
( N'A8R559', '14:50', 3 ),
( N'A4S879', '14:50', 3 )
select
*
from
(
select
placa ,
hora ,
vuelta
from
@tabla t
) source pivot ( max(source.hora) for vuelta in ( [1], [2], [3] ) ) as pivotable;
Efectivamente la solucion es PIVOT, te paso el script con tablas temporales para que lo analices.. cuentanos que ta te va
