Třídová akce

Kód:

10

Tělo:

SELECT 
#IB
  SUM(Cast(A.StringFieldValue as Float))
#MS
  SUM(Cast(A.StringFieldValue as Float))
#ORA
  SUM(TO_NUMBER(A.StringFieldValue,'9999999999999D9999999999999999', ' NLS_NUMERIC_CHARACTERS = ''. '' '))
#ALL
FROM WageListPartial B  
JOIN WagePeriods C ON B.WagePeriod_ID = C.ID AND
  ({WPeriodFunction}(C.{WPeriodFieldName}) =
    (SELECT {WPeriodFunction}({WPeriodFieldName})
     FROM WagePeriods
     WHERE ID = :WPeriodID)
  ) AND
  (C.DateFrom$DATE {RelationalOperator}
    (SELECT DateFrom$DATE
     FROM WagePeriods
     WHERE ID = :WPeriodID)
  )
JOIN {UserTableName} A ON A.ID = B.ID
WHERE 
  B.WorkingRelation_ID = :WrkRelationID AND
  A.CLSID = :CLSID AND
  A.FieldCode = :FieldCode

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