Create a table
CREATE TABLE [dbo].[Test]( [ID] [int] IDENTITY(1,1) not NULL, [RQ] [Date] NULL, [SR] [int] NULL, [ZC] [int] NULL) on [PRIMARY]
Inserting data
INSERT into [Demo].[dbo].[Test]([ID],[RQ],[SR],[ZC])VALUES(1,'2017-10-01 00:00:00', -,NULL);INSERT into [Demo].[dbo].[Test]([ID],[RQ],[SR],[ZC])VALUES(2,'2017-10-02 00:00:00',NULL, -);INSERT into [Demo].[dbo].[Test]([ID],[RQ],[SR],[ZC])VALUES(3,'2017-10-03 00:00:00', -,NULL);INSERT into [Demo].[dbo].[Test]([ID],[RQ],[SR],[ZC])VALUES(4,'2017-10-04 00:00:00',NULL,Ten);INSERT into [Demo].[dbo].[Test]([ID],[RQ],[SR],[ZC])VALUES(5,'2017-10-06 00:00:00', +,NULL);
Date fields are not duplicated
SELECT T.rq, T.SR, T.zc, ( SELECTSUM-sum(ZC) from test WHERE <= t.rq ) as Balance from Test as t
Date is not unique, use the self-increment field to differentiate:
SELECT T.id,t.rq, T.SR, T.zc, ( SELECTSUM-sum(ZC) from Test WHERE <= t.id ) as balance from test as t
Effect
SQL Journal balance Query