StartDowntime datetime,

EndDowntime datetime,

ElapsedSecs int,

Dryer int default 0,

DowntimeCode int default 0

);

(StartDowntime, EndDowntime, ElapsedSecs) values

('2022-01-17 08:00', '2022-01-17 09:05', 3900);

SELECT

StartDowntime AS DownDatetime

, 600 AS ElapsedSeconds

, ElapsedSecs AS RemainingSeconds

, EndDowntime

, 1 AS Lvl

FROM tblOKDryerDowntime

UNION ALL

SELECT

DATEADD(second, ElapsedSeconds, DownDatetime)

, iif(RemainingSeconds > ElapsedSeconds, 600, RemainingSeconds)

, iif(RemainingSeconds > ElapsedSeconds, RemainingSeconds - ElapsedSeconds, 0)

, EndDowntime

, Lvl + 1

FROM RCTE

WHERE DownDatetime < EndDowntime

AND RemainingSeconds > 0

)

SELECT DownDatetime, ElapsedSeconds

FROM RCTE

ORDER BY DownDatetime;