--======DUMMY TABLE=========================
DECLARE @Meetings TABLE(ID int IDENTITY(1, 1), Name nvarchar (100), Start [time], [End] [time])
INSERT INTO @Meetings
VALUES
('A', '12:00:00', '13:00:00'),
('B', '14:00:00', '14:30:00'),
('C', '15:00:00', '16:00:00')
--======ACTUAL QUERY================
DECLARE @Name nvarchar(100),
@Start [time],
@End [time]
SET @Name = 'X'
SET @Start = '14:35:00'
SET @End = '14:45:00'
--=============WILL BE INSERTED===========
IF NOT EXISTS(SELECT * FROM @Meetings
WHERE (@Start BETWEEN [Start] AND [End])
OR (@End BETWEEN [Start] AND [End]))
BEGIN
INSERT INTO @Meetings
VALUES (@Name, @Start, @End)
END
--=============WILL NOT BE INSERTED===========
SET @Name = 'Z'
SET @Start = '14:15:00'
SET @End = '14:35:00'
IF NOT EXISTS(SELECT * FROM @Meetings
WHERE (@Start BETWEEN [Start] AND [End])
OR (@End BETWEEN [Start] AND [End]))
BEGIN
INSERT INTO @Meetings
VALUES (@Name, @Start, @End)
END
SELECT * FROM @Meetings