Třídová akce

Kód:

3

Tělo:

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

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