Třídová akce

Kód:

6

Tělo:

SELECT 
  A.ShiftDate$Date, A.InitialHour, P.RelativeInitialHour, P.HoursPause 
FROM 
  ShiftCalendar2 A 
  JOIN ShiftCalendar3 P ON P.Parent_ID=A.ID
WHERE 
  A.Parent_ID = :Parent_ID  AND 
  (A.ShiftDate$DATE >= :DateFrom) AND (A.ShiftDate$DATE <= :DateTo)
ORDER BY
  A.ShiftDate$Date + (A.InitialHour/24)

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