select
max(CU.ID)
from
GPMCateringUnits cu
where
cu.ID <> :ID and
cu.docdate$date = :DocDate and
coalesce(cu.BusOrder_ID, '0000000000') = coalesce(:BusOrder_ID, '0000000000')
and coalesce(cu.BusTransaction_ID, '0000000000') = coalesce(:BusTransaction_ID, '0000000000')
and coalesce(cu.BusProject_ID, '0000000000') = coalesce(:BusProject_ID, '0000000000')Generated by ABRA Software a.s. 27.10.2021 16:35:32