您所在位置：主题：SELECT语句请教
gpyzcp
[专家分：170] 发布于 2006-05-10 21:10:00
不用游标怎么实现如下表最后一列的统计
就是数据截取的问题 初始库存
NULL NULL NULL 入库 出库 19772640
2005-09-01 00:00:00.000 LR00000011生产入库 2000 0 19774640
2005-09-02 00:00:00.000 LR00000007生产入库 20000 0 19794640
2005-09-10 00:00:00.000 LC00000037其他 0 1000 19793640
2005-09-16 00:00:00.000 LC00000026销售 0 4000 19789640
2005-09-16 00:00:00.000 LC00000027销售 0 4000 19785640
2005-09-17 00:00:00.000 LC00000028销售 0 1000000 18785640
2005-09-17 00:00:00.000 LC00000029欠条 0 4000000 14785640
2005-09-23 00:00:00.000 LC00000044改签改袋 0 2000 14783640
2005-09-24 00:00:00.000 LC00000056销售 0 5000 14778640
2005-09-24 00:00:00.000 LC00000057销售 0 10000 14768640
2005-09-26 00:00:00.000 LC00000062销售 0 1000 14767640
就是数据截取的问题 初始库存
NULL NULL NULL 入库 出库 19772640
2005-09-01 00:00:00.000 LR00000011生产入库 2000 0 19774640
2005-09-02 00:00:00.000 LR00000007生产入库 20000 0 19794640
2005-09-10 00:00:00.000 LC00000037其他 0 1000 19793640
2005-09-16 00:00:00.000 LC00000026销售 0 4000 19789640
2005-09-16 00:00:00.000 LC00000027销售 0 4000 19785640
2005-09-17 00:00:00.000 LC00000028销售 0 1000000 18785640
2005-09-17 00:00:00.000 LC00000029欠条 0 4000000 14785640
2005-09-23 00:00:00.000 LC00000044改签改袋 0 2000 14783640
2005-09-24 00:00:00.000 LC00000056销售 0 5000 14778640
2005-09-24 00:00:00.000 LC00000057销售 0 10000 14768640
2005-09-26 00:00:00.000 LC00000062销售 0 1000 14767640
