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

原创于 2021-02-01 20:30:36 发布 · 503 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

19 篇文章

订阅专栏

本文介绍了一种使用SQL语句实现数据筛选和插入的方法。具体步骤包括：从指定表中选择符合特定条件的数据，计算累积数量，并将满足条件的记录插入到另一个表中。示例SQL语句展示了如何实现这一过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

累积统计数量和总数量后

插入其他表中

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

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)