Třídová akce

Kód:

3

Tělo:

SELECT A.ID, A.ValidFrom$DATE, A.ObjVersion, A.System FROM CalcExpressions A
 WHERE A.System = 'N' AND A.ValidFrom$DATE >= :MaxDate AND
  A.FieldCode = :FieldCode AND A.Parent_ID = :CalcChart AND A.ID <> :OBJID AND
  (NOT EXISTS (SELECT C.ID FROM CalcExpressions C
    WHERE C.System = 'A' AND C.ValidFrom$DATE > :MaxDate AND C.FieldCode = :FieldCode AND C.Parent_ID = :CalcChart)
  OR A.ValidFrom$DATE < (
   SELECT Min(B.ValidFrom$DATE) FROM CalcExpressions B
    WHERE B.System = 'A' AND B.ValidFrom$DATE > :MaxDate AND B.FieldCode = :FieldCode AND B.Parent_ID = :CalcChart))

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