create table Orders ( [CodeGoods] [nvarchar](50) NULL, [Validate] [datetime] NULL, [Mass] [int] NULL ); insert into Orders values ('0001', '20211014', 5000), ('0002', '20211014', 4000), ('0003', '20211015', 4000); SELECT * FROM Orders; create table Rest ( [CodeGoods] [nvarchar](50) NULL, [Validate] [datetime] NULL, [Mass] [int] NULL ); insert into Rest values ('0001', '20211014', 1000), ('0001', '20211015', 6000), ('0001', '20211016', 10000), ('0002', '20211015', 10000), ('0003', '20211015', 10000), ('0005', '20211015', 10000); SELECT * FROM rest;

WITH cte1 AS ( SELECT CodeGoods, Validate, Mass, SUM(Mass) OVER (PARTITION BY CodeGoods ORDER BY Validate) CumMass FROM Rest ), cte2 AS ( SELECT cte1.CodeGoods, cte1.Validate, cte1.Mass, COALESCE(LAG(CumMass) OVER (PARTITION BY cte1.CodeGoods ORDER BY cte1.Validate), 0) LagMass FROM cte1 ) SELECT cte2.CodeGoods, cte2.Validate, cte2.Mass FROM cte2 JOIN Orders ON Orders.CodeGoods = cte2.CodeGoods AND Orders.Mass >= cte2.LagMass