Objektová akce

Kód:

4

Tělo:

SELECT 0, S.ID, '0000000000', S.Hidden, CAST(S.Name AS VARCHAR(300))
FROM ActionPriceListRestrictionUses A
JOIN Stores S ON S.ID=A.Store_ID
WHERE 
  A.RestrictionType = 0 AND
  A.Parent_ID = :OBJID
UNION ALL
SELECT 1, F.ID, F.Firm_ID, F.Hidden, CAST(F.Name AS VARCHAR(300))
FROM ActionPriceListRestrictionUses A
JOIN Firms F ON F.ID=A.Firm_ID
WHERE 
  A.RestrictionType = 1 AND
  A.Parent_ID = :OBJID
ORDER BY 1, 5

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