Brahmanand Shukla (10/6/2016)

---

You are getting the error because you have not given the Alias to the Query Table. I gave it Alias and it got successfully compiled.

Please find the modified...

SELECT 2016 AS Tahun

,'Jun' AS bulan

,dbo.uf_get_koddana(BYFUND.DANA) AS DANA

,SUM(ISNULL(DISB.DISBAMT, 0)) AS JUMLAHPINJAMAN

,SUM(ISNULL(DISB.CAJ, 0)) AS CAJ

,sum(BYFUND.cost_amt) AS ByrPokok

,sum(BYFUND.profit_amt) AS ByrCaj

,sum(BYFUND.savings_amt) AS ByrSimpanan

,sum(BYFUND.resit_amount) AS JumKutip

,sum(isnull(ADJ.cost_amt, 0)) AS laraspokok

,sum(isnull(ADJ.profit_amt, 0)) AS larascaj

,sum(isnull(ADJ.txn_amt, 0)) AS...

ChrisM@Work (10/4/2016)

---

nazirulfitrifauzi (10/4/2016)

---

SELECT 'KESELURUHAN' AS STATE,

'KESELURUHAN' AS BRANCH,

dbo.uf_get_koddana(h.funding_scheme) AS Dana,

Count(*) AS cnt_all,

Sum(h.approved_limit) AS sum_all,

Sum(isnull(w.wo_amt,0)) AS sum_wo,

Sum(isnull(RECOVERED_AMOUNT,0)) AS sum_wb,

Sum(case when bulantgkbil >= 7 and h.account_status not in (1,9,15) then 1 else...

I got an error : Msg 313, Level 16, State 2, Line 1

An insufficient number of arguments were supplied for the procedure or function ssma_oracle.trunc.

SELECT 'KESELURUHAN' AS STATE,

'KESELURUHAN' AS BRANCH,

dbo.uf_get_koddana(h.funding_scheme) AS Dana,

Count(*) AS cnt_all,

Sum(h.approved_limit) AS sum_all,

Sum(isnull(w.wo_amt,0)) AS sum_wo,

Sum(isnull(RECOVERED_AMOUNT,0)) AS sum_wb,

Sum(case when bulantgkbil >= 7 and h.account_status not in (1,9,15) then 1 else 0 END)...