https://www.c-sharpcorner.com/forums/select-value-from-row1-ms-sql
Solution from one table work...from multiple tables?
- with cte as (
- select iznos_sa_porezom as 'Duguje', '0.00' as 'Potražuje',
- ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RN from dbo.mp_ulazni_racun_roba_lista
- where redni_broj IS NOT NULL group by iznos_sa_porezom
- union all
- select iznos_sa_porezom as 'Duguje', '0.00' as 'Potražuje',
- ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RN from dbo.mp_ulazni_racun_ostalo_lista
- where redni_broj IS NOT NULL group by iznos_sa_porezom)
- select [Duguje], [Potražuje],
- (SELECT sum(Duguje-Potražuje) FROM cte t2 WHERE t2.RN <= cte.RN) AS Saldo
- from cte