Třídová akce

Kód:

1

Tělo:

SELECT
  Sum(CAST(B.StringFieldValue as float))
FROM
  MonthWRelationInformation A, {UserTableName} B
WHERE
  (A.ID = B.ID) AND
  ((A.WorkingRelation_ID = :WrkRelationID) or (:WrkRelationID = '0000000000')) AND
  ((A.WagePeriod_ID = :WagePeriodID) or (:WagePeriodID = '0000000000')) AND  
  ((A.WagePeriodAuthor_ID = :WagePeriodAuthorID) or (:WagePeriodAuthorID = '0000000000')) AND
  (B.FieldCode = :FieldCode) AND (B.CLSID = :CLSID)

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