เลือกช่วงเวลา ในระบบจองครับ ไม่รู้จะทำเงื่อนไข อย่างไรดี sql server

declare @new_time_start as time, @new_time_end as time
set @new_time_start = cast('07:01:00' as time)
set @new_time_end = cast('09:00:00' as time)

select * 
from (
	select 'ID001' ID, cast('08:01:00' as time) time_start, cast('10:00:00' as time) time_end
	union all
	select 'ID001' ID, cast('10:01:00' as time) time_start, cast('12:00:00' as time) time_end
) tbTemp
where time_start between @new_time_start and @new_time_end
  or  time_end   between @new_time_start and @new_time_end