Třídová akce

Kód:

10

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
WHERE A.Employee_ID =:EMPLOYEE AND A.WagePeriod_ID=:WAGEPERIOD

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