Objektová akce

Kód:

14

Tělo:

SELECT 
  S.Code || ' ' || S.Name || 
  CASE 
    WHEN A.Period_ID IS NULL THEN '/'
    ELSE '/' || P.Code || '/' 
  END ||     
#IB
IB_DATETOSTRING(A.ClosingDate$DATE, 'dd.mm.yyyy')
#ORA
IB_DATETOSTRING(A.ClosingDate$DATE, 'dd.mm.yyyy')
#MS
dbo.IB_DATETOSTRING(A.ClosingDate$DATE, 'dd.mm.yyyy')
#ALL
  AS DisplayName 
FROM StoreClosings A
JOIN Stores S ON S.ID = A.Store_ID
LEFT JOIN Periods P ON P.ID = A.Period_ID
WHERE A.ID = :OBJID

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