0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

-- SO3241450

CREATE TABLE #SO3241450 (
    Weekno int NOT NULL
    ,DayOfWeek int NOT NULL
    ,FromTime time NOT NULL
    ,ToTime time NOT NULL
)

INSERT INTO #SO3241450 VALUES
(1,        2,             '10:00',       '14:00')
,(1,         3,             '10:00',       '14:00')
,(2,         3,             '08:00',       '13:00')
,(2,         4,             '09:00',       '13:00')
,(2,         5,             '14:00',       '22:00')
,(3,         1,             '06:00',       '13:00')
,(3,         4,             '06:00',       '13:00')
,(3,         5,             '14:00',       '22:00')
SELECT *
FROM #SO3241450

fork query

created jul 13 10 Cade Roux