UPDATE t仓库数据 SET t仓库数据_库存数量= t仓库数据_库存数量 - @COUNT WHERE t仓库数据_仓库编码=@BM你的仓库编码=商品编码?
SELECT 商品编码,SUM(数量) AS 数量合计 INTO #tmp_pos1 FROM POS流水帐 (nolock)
GROUP BY 商品编码 DECLARE @BM VARCHAR(30),@COUNT INTEGER
SET NOCOUNT ON DECLARE CUR_COUNT CURSOR FOR SELECT 商品编码,数量合计 FROM #tmp_pos1
OPEN CUR_COUNT FETCH NEXT FROM CUR_COUNT into @BM,@COUNT WHILE @@FETCH_STATUS = 0 BEGIN UPDATE t仓库数据 SET t仓库数据_库存数量= t仓库数据_库存数量 - @COUNT WHERE t仓库 数据_商品编码=@BM FETCH NEXT FROM CUR_COUNT INTO @BM,@COUNT END DEALLOCATE CUR_COUNT SET NOCOUNT OFF --删除临时表 drop table #tmp_pos1
GROUP BY 商品编码 DECLARE @BM VARCHAR(30),@COUNT INTEGER
SET NOCOUNT ON
DECLARE CUR_COUNT CURSOR
FOR SELECT 商品编码,数量合计 FROM #tmp_pos1
OPEN CUR_COUNT
FETCH NEXT FROM CUR_COUNT into @BM,@COUNT
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE t仓库数据 SET t仓库数据_库存数量= t仓库数据_库存数量 - @COUNT WHERE t仓库 数据_商品编码=@BM
FETCH NEXT FROM CUR_COUNT INTO @BM,@COUNT
END
DEALLOCATE CUR_COUNT
SET NOCOUNT OFF --删除临时表
drop table #tmp_pos1