Torna al Thread

select Anno, Mese, Totale, Saldo=Totale+isnull((select sum(t2.Totale) from TUATABELLA t2 where (t2.anno*12+t2.mese)<(t1.anno*12+t1.mese)),0) from TUATABELLA t1 order by anno,mese
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5