QueryBuilder issue on Running sum
Hi, the Query Builder has problem to parse this query that has a running sum inside:
SELECT
M.DataContabile,
M.DataValuta,
ROUND(M.Dare, 2) AS Dare,
ROUND(M.Avere, 2) AS Avere,
ROUND(M.Avere - M.Dare,2) AS Saldo,
ROUND(SUM(M.Avere - M.Dare) OVER (ORDER BY IIF (M.Avere - M.Dare = 0, 1, 0 ), M.DataContabile),2) AS SaldoProgressivo,
M.CodiceCausale,
C.DescrizioneCausale,
M.Aggiuntive1,
M.Aggiuntive2,
M.DescrizioneMovimento,
M.Banca,
M.DataImportazione
FROM BankChecker.dbo.Movimenti M
LEFT OUTER JOIN BankChecker.dbo.Causali C
ON M.CodiceCausale = C.Codice
Many thanks!
SELECT
M.DataContabile,
M.DataValuta,
ROUND(M.Dare, 2) AS Dare,
ROUND(M.Avere, 2) AS Avere,
ROUND(M.Avere - M.Dare,2) AS Saldo,
ROUND(SUM(M.Avere - M.Dare) OVER (ORDER BY IIF (M.Avere - M.Dare = 0, 1, 0 ), M.DataContabile),2) AS SaldoProgressivo,
M.CodiceCausale,
C.DescrizioneCausale,
M.Aggiuntive1,
M.Aggiuntive2,
M.DescrizioneMovimento,
M.Banca,
M.DataImportazione
FROM BankChecker.dbo.Movimenti M
LEFT OUTER JOIN BankChecker.dbo.Causali C
ON M.CodiceCausale = C.Codice
Many thanks!
Sorry for the late response. We will this problem soon. By the way, what is your database server?