Query fuera de Rango cOmO??

[Thumper]

Prueba algo asi:

declare @colectivo table ( colectivo int )
declare @viaje table ( colectivo int, hi datetime, hf datetime )

declare @hi datetime
declare @hf datetime
set @hi = '20080101 11:00:00'
set @hf = '20080101 14:00:00'

insert into @colectivo values( 1 )
insert into @colectivo values( 2 )
insert into @colectivo values( 3 )

insert into @viaje values( 1, '20080101 12:00:00', '20080101 13:00:00' )
insert into @viaje values( 1, '20080101 09:00:00', '20080101 12:00:00' )
insert into @viaje values( 1, '20080101 12:00:00', '20080101 16:00:00' )
insert into @viaje values( 1, '20080101 15:00:00', '20080101 17:00:00' )
insert into @viaje values( 1, '20080101 00:00:00', '20080101 17:00:00' )

SELECT *
FROM @colectivo
WHERE colectivo not in ( select colectivo
from @viaje
where ( hi >= @hi and hi < @hf ) or
( hi <= @hi and hf <= @hf ))

Saludos