Třídová akce

Kód:

12

Tělo:

SELECT
  SUM(A.REQUIRED *
      (SELECT b.IVALUE
       FROM sys$decidetablebool b
       WHERE b.boolvalue <> a.ispercent))
  +
  SUM(A.REQUIREDAMOUNT *
      (SELECT b.IVALUE
       FROM sys$decidetablebool b
       WHERE b.boolvalue = a.ispercent))
  AS REQUIRED
  FROM Docks A
  JOIN DockTypes DT ON DT.ID = A.DockType_ID
  WHERE A.Employee_ID =:EMPLOYEE AND A.WagePeriod_ID=:WAGEPERIOD AND
        DT.CompToMinimum = 'N'

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