check Record (Slot) is already exists between Start and End time in SQL Server
In this article I will show you how to check Record is already exists between Start and End time . I have a table ,its having start and end time column with 3 rows(or it may be n of rows).so i am putting here my SQL query to get those records if any record have time between Start and end time . DECLARE @mytable as Table ( StartTime time, EndTime time ) INSERT INTO @mytable VALUES ('08:00', '08:30'), ('10:30', '12:30'), ('12:30', '14:15') DECLARE @StartTime time, @EndTime time SELECT @StartTime = '14:15', @EndTime = '18:15' SELECT * FROM @mytable WHERE ( StartTime < @EndTime AND EndTime > CASE WHEN @StartTime > @EndTime THEN '00:00' ELSE @StartTime END ) OR ( @StartTime > @EndTime AND StartTime > EndTime ) OR ( @StartTime < @EndTime AND StartTime > EndTime ...