Třídová akce

Kód:

1

Tělo:

SELECT
  COALESCE(F.Firm_ID, F.ID) Firm_ID,
  MAX(CASE
    WHEN (A.ValidTo$DATE = 0) OR (A.ValidTo$DATE IS NULL)  THEN 9999999999
    WHEN (A.ValidTo$DATE <> 0) AND (A.ValidTo$DATE IS NOT NULL) THEN A.ValidTo$DATE
   END) LatestDate,
  MAX(A.ID) LatestID
FROM
  Contracts A
  JOIN Firms F ON F.ID = A.{FirmFieldName}
WHERE
  A.{FirmFieldName} {Firm_IDs} AND
  ((A.ValidTo$DATE >= :DateFrom) OR (A.ValidTo$DATE = 0)) AND
  A.DocQueue_ID {DocQueue_IDs} AND  
  A.AutoDataProcessingPermit = 'A' 
GROUP BY
  COALESCE(F.Firm_ID, F.ID)

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