sqlserver 练习题目(存储过程：循环erp数据表，生成另一个表数据)

– ##表结构 ###
use test_db;

CREATE TABLE [dbo].[GYGDFT](
[任务单号] varchar NOT NULL,
[任务序号] [int] NULL,
[品号] varchar NULL,
[生产数量] [int] NULL,
[备注] varchar NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[GYJHD](
[计划单号] varchar NOT NULL,
[计划序号] [int] NULL,
[品号] varchar NULL,
[计划出货数量] [int] NULL,
[计划日期] [date] NULL
) ON [PRIMARY]

drop table [TEST_REPORT];
CREATE TABLE [dbo].[TEST_REPORT](
[任务单号] varchar NULL,
[任务序号] [int] NULL,
[品号] varchar NULL,
[生产数量] [int] NULL,
[计划出货数量] [int] NULL,
[分配数量] [int] NULL,
[生产剩余数量] [int] NULL,
[计划单号] varchar NULL,
[计划序号] [int] NULL,
[计划日期] [date] NULL
) ON [PRIMARY]

GO

– =========学习阶段：查询任务单号 并分页 开始================
select * from
(
select row_number()over(order by 任务序号 )temprownumber,*
from (select top 2 tempcolumn=0,*
from GYGDFT
)t
)tt where temprownumber>1

select top 1 *
from
(
sele