SELECT
Sum(CAST(B.StringFieldValue as float))
FROM
WageListCommon A, {UserTableName} B
WHERE
(A.ID = B.ID) AND
((A.Employee_ID = :EmployeeID) OR (:EmployeeID = '0000000000')) AND
(B.FieldCode = :FieldCode) AND (B.CLSID = :CLSID) AND
A.WagePeriod_ID IN (SELECT AValue from
GetPreviousNPeriods(:WPeriodID, :CountBack))Generated by ABRA Software a.s. 27.10.2021 16:34:36