QueryBuilder issue on Running sum

Avatar
  • updated
  • Completed
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!

Avatar
Anonymous
Hi,

Sorry for the late response. We will this problem soon. By the way, what is your database server?
Avatar
Comparin Fabio
Here you are:
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
Have a good day.
Avatar
Anonymous
The bug is fixed.
Avatar
Comparin Fabio
Thank you!