Třídová akce

Kód:

4

Tělo:

SELECT Min(A.InitialHour) as MinTime, Max(A.InitialHour + HoursShift) as MaxTime FROM SHIFTCALENDAR2 A 
JOIN SHIFTCALENDAR S ON (S.ID = A.PARENT_ID)
LEFT JOIN PLMWORKPLACES P ON (S.ID = P.SHIFTCALENDAR_ID)
WHERE (A.ShiftDate$DATE = :ShiftDate) and (P.ID = :WorkPlaceID)

Generated by ABRA Software a.s. 27.10.2021 16:34:49