SQL server筛选出满足需求的数量的数据插入其他表中

累积统计数量和总数量后

插入其他表中

筛选出满足需求的数量然后退出

insert into [SendReelTable] 
SELECT TOP 3 * FROM(SELECT '' as [SAVEBIN],'0343000132' as [PartNo],
100000 as [REQQTY],'' as [PickReelID],ReelQty as [PickReelQTY],
binNunber as [ShelfBin],'' as [outPickReelID],0 as [outPickReelQTY],
'待發料' as [State],ReelData as [pickReelData],'22222222222' as [SMTWO],
'' as [WORKCENTER],0 as [lackOfMaterialCount],
0 as [PartNoTotalQty],'01/01/01 00:00:00' as [StartDatetime],
'' as [SendReelStyle],ReelDateCode as [DateCode],
SUM(ReelQty)OVER(ORDER BY ReelQty rows BETWEEN unbounded preceding and current row) AS sumReelQtyAsc,0 as sumReelQty 
FROM [SaveTable] Where ReelPartNo ='0343000132' AND [State] !='被選中' AND ReelPartNo !=  ''  AND [isOpen] = 1 ) AS t 
WHERE sumReelQtyAsc<=(100000+PickReelQTY)