Sql 获取满足给定汇总值的前N条记录

declare @ivt table(Qty int,Code nvarchar(10))
insert into @ivt(Qty,Code)
select 7,'a' union
select 3,'b' union
select 4,'c' 
select * from @ivt order by code 

declare @tb table(Id int ,Qty int,Code nvarchar(10))
insert into @tb(Id,Qty,Code)
select 1, 1,'a' union
select 2,2,'b' union
select 3,3,'c' union
select 4,2,'a' union
select 5,1,'b' union
select 6,3,'a' union
select 7,1,'c' union
select 8,3,'a' union
select 9,2,'c' union
select 10,4,'a' 
select * from @tb order by id

select a.Id,a.Qty,a.Code from @tb a join @tb b on b.id<=a.Id and a.Code=b.Code
join @ivt c on c.Code=a.Code
group by a.Id,a.Code,a.Qty,c.Qty
having sum(b.qty)<=c.Qty

 

https://dba.stackexchange.com/questions/74846/sql-select-top-x-rows-having-sum-limit

DECLARE @Limit FLOAT
SELECT @Limit = 30

SELECT
    o1.Id
    , o1.Cost
    , o1.Category
FROM
    MyOrders o1
    -- Join all orders with same category and inferior ID
    INNER JOIN MyOrders o2 ON o2.ID <= o1.ID AND o1.Category = o2.Category
GROUP BY
    o1.Id
    , o1.Cost
    , o1.Category
HAVING
    SUM(o2.Cost) < @Limit
ORDER BY
    ID