I want Select ShiftNo

[abdelrahmansaid]

ID StartShift EndShift ShiftNo
1 10:00:01 22:00:00 1
2 22:00:01 10:00:00 2

DECLARE @timenow time
SET @timenow = '01:35:00'

i want Select ShiftNo

[JamesK]

SELECT ShiftNo FROM YourTable
WHERE 
   StartShift <= @timeNow
   AND EndShift >= @timeNow;