Interesantno, očekuješ pomoć a mrzi te.
Nalozi:
Code:
VREMEPOCETKA VREMEKRAJA
09:00:00.000 10:00:00.000
12:00:00.000 12:30:00.000
Sati:
Code:
SATOD SATDO
08:00:00.000 20:00:00.000
Sql
Code:
SELECT * FROM
(
SELECT
t.vremekraja pocetak,
(
SELECT MIN(t2.vremepocetka)
FROM nalozi as t2
WHERE t2.vremepocetka >= t.vremekraja
) AS kraj
FROM nalozi as t
UNION
SELECT
(SELECT MIN(satod) FROM sati) pocetak,
MIN(vremepocetka) kraj
FROM nalozi
UNION
SELECT
MAX(vremekraja) pocetak,
(SELECT MIN(satdo) FROM sati) kraj
FROM nalozi
)
WHERE pocetak < kraj
ORDER BY pocetak
Rezultat:
Code:
POCETAK KRAJ
08:00:00.000 09:00:00.000
10:00:00.000 12:00:00.000
12:30:00.000 20:00:00.000