Třídová akce

Kód:

6

Tělo:

select
  sum(Cu.planeddailycosts) as PlanedCosts, sum(cu.realdailycosts) as RealCosts, count(cu.id)
from
  GPMCateringUnits cu
where
  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') and
  cu.docdate$date >= :StartDate and
  cu.docdate$date <= :EndDate

Generated by ABRA Software a.s. 27.10.2021 16:35:32