Třídová akce

Kód:

8

Tělo:

SELECT 
  B.Name, 
  A.ScriptID, 
  A.CompiledScriptData, 
  B.UsageState, 
  CASE WHEN (B.HashPassword = '') THEN A.ScriptData ELSE null END,
  A.CompilerVersion 
FROM 
  ScriptPackages2 A
  JOIN ScriptPackages B ON (A.Parent_ID=B.ID) and (Upper(B.Name) = Upper(:PackageName))
WHERE 
  (Upper(A.ScriptID)=Upper(:ScriptID)) 
  AND (A.ScriptKind=:ScriptKind)
  AND (B.UsageState>:UsageLevel) AND (A.Compiled='A') 
ORDER BY 
  B.RunOrder

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