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

李小域Chaos

于 2021-02-01 20:30:36 发布

阅读量502

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/lee_u/article/details/113528587

数据库专栏收录该内容

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)