发运物料价值_proc.sql

来自「java开发数据库源码,关于仓库系统的数据库,功能齐全,测试成功」· SQL 代码 · 共 21 行

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='发运物料价值_PROC' AND TYPE='P')
DROP PROC 发运物料价值_PROC
GO
CREATE PROC  发运物料价值_PROC
@CO_TO INT,
@CO_FR INT
AS

CREATE TABLE [#发运物料价值] (
	[销售单号] [int] ,
	[行] [int]  ,
	[客户编码] [varchar] (10) ,
	[物料编码] [varchar] (30) ,
	[计量单位] [varchar] (10),
	[出库数量] [numeric](18, 6)DEFAULT(0.00) ,
        [发票金额] [numeric](18, 6) DEFAULT(0.00))
INSERT INTO #发运物料价值 (销售单号,行,客户编码,物料编码,计量单位,出库数量,发票金额)
SELECT 销售单号,行,客户编码,物料编码,计量单位,出库数量,发票金额
FROM 销售出库单明细表 WHERE 销售单号>=@CO_TO  AND 销售单号<=@CO_FR
SELECT *FROM #发运物料价值