gistfile1.sql

select 
AccTrns_Dept AccTrns_Dept, min(NO_NAME) DEPT_NAME, 
AccTrns_OffBalance AccTrns_OffBalance, 
GETDATEDETAIL(AccTrns_Date,?) dDATE, case
                                               when DHalf.ACCTRNSHALF_INVERSE=1 and
                                                    KHalf.ACCTRNSHALF_INVERSE=1 then 1
                                               when DHalf.ACCTRNSHALF_INVERSE=-1 and
                                                    KHalf.ACCTRNSHALF_INVERSE=1 then 2
                                               when DHalf.ACCTRNSHALF_INVERSE=-1 and
                                                    KHalf.ACCTRNSHALF_INVERSE=-1 then 3
                                               when DHalf.ACCTRNSHALF_INVERSE=1 and
                                                    KHalf.ACCTRNSHALF_INVERSE=-1 then 4
                                               else 0
                                             end quadrant, 
 coalesce(DAccLevel.AccInc_FltAcc_ID, DHalf.ACCTRNSHALF_ACCNT_ID) D_ID, min(DAcc.Accnt_Num) DAccNum, min(DAcc.Accnt_Name) DAccName, 
 coalesce(KAccLevel.AccInc_FltAcc_ID, KHalf.ACCTRNSHALF_ACCNT_ID) K_ID, min(KAcc.Accnt_Num) KAccNum, min(KAcc.Accnt_Name) KAccName, 
 sum(AccTrns_MainTotal) total_sum
 from AccntTrans 
join AccntTransHalfs DHalf
 on DHalf.AccTrnsHalf_AccTrns_ID=AccTrns_XmlObj_ID+0 and DHalf.AccTrnsHalf_Half=1
   left join AccountIncidences DAccLevel 
     join Accounts DAcc on DAcc.Accnt_XmlObj_ID=coalesce(DAccLevel.AccInc_FltAcc_ID, DHalf.ACCTRNSHALF_ACCNT_ID)
   on DAccLevel.AccInc_TblAcc_ID=DHalf.ACCTRNSHALF_ACCNT_ID+0 and DAccLevel.AccInc_Level=?
join AccntTransHalfs KHalf
 on KHalf.AccTrnsHalf_AccTrns_ID=AccTrns_XmlObj_ID+0 and KHalf.AccTrnsHalf_Half=-1
   left join AccountIncidences KAccLevel 
     join Accounts KAcc on KAcc.Accnt_XmlObj_ID=coalesce(KAccLevel.AccInc_FltAcc_ID, KHalf.ACCTRNSHALF_ACCNT_ID)
   on KAccLevel.AccInc_TblAcc_ID=KHalf.ACCTRNSHALF_ACCNT_ID+0 and KAccLevel.AccInc_Level=?
   join AccountIncidences KAccInc on KAccInc.AccInc_FltAcc_ID=? and KAccInc.AccInc_TblAcc_ID=KHalf.ACCTRNSHALF_ACCNT_ID+0
join Named_Objects on NO_OBJ_ID=AccTrns_Dept 
where AccTrns_Datetime>=? and AccTrns_Datetime<? and AccTrns_Dept=? 
group by 1, 3, 4, 5, 6, 9