Objektová akce

Kód:

2

Tělo:

SELECT CASE WHEN LegalPerson = 'A' THEN '4K3EXM5PQBCL35CH000ILPWJF4' ELSE 'KZU1IUB5WB5415T4LXY5MLBMY4' END CLSID, 'ResidenceAddress_ID' FieldName, ID Firm_ID, NULL Person_ID
FROM Firms 
WHERE ResidenceAddress_ID = :OBJID

UNION ALL

SELECT CASE WHEN LegalPerson = 'A' THEN '4K3EXM5PQBCL35CH000ILPWJF4' ELSE 'KZU1IUB5WB5415T4LXY5MLBMY4' END CLSID, 'ElectronicAddress_ID' FieldName, ID Firm_ID, NULL Person_ID
FROM Firms
WHERE ElectronicAddress_ID = :OBJID

UNION ALL

SELECT CASE WHEN IsEmployee = 'N' THEN 'WEC02QYERNCL35CH000ILPWJF4' ELSE '4C0STLT54UG455A3WY4YG4FGZK' END CLSID, 'Address_ID' FieldName, NULL Firm_ID, ID Person_ID
FROM Persons
WHERE Address_ID = :OBJID

UNION ALL

SELECT 'CPP5AZU1CVF13JXS00KEZYD5AW' CLSID, 'TemporaryAddress_ID' FieldName, NULL Firm_ID, Person_ID Person_ID
FROM Employees
WHERE TemporaryAddress_ID = :OBJID

UNION ALL

SELECT 'AT011EZZ5DFO115YJ1HCZJDXJ4' CLSID, 'Address_ID' FieldName, Parent_ID Firm_ID, NULL Person_ID
FROM FirmOffices 
WHERE Address_ID = :OBJID

UNION ALL

SELECT 'AT011EZZ5DFO115YJ1HCZJDXJ4' CLSID, 'ElectronicAddress_ID' FieldName, Parent_ID Firm_ID, NULL Person_ID
FROM FirmOffices 
WHERE ElectronicAddress_ID = :OBJID

UNION ALL

SELECT 'JZ22ZRJ0NNU4B10XV5SWGOHYR4' as CLSID, 'Address_ID' FieldName, Parent_ID Firm_ID, Person_ID Person_ID
FROM FirmPersons 
WHERE Address_ID = :OBJID

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