销售退货_proc.sql

SQL server 进销存软件数据库设计。大家积极下载

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),
    [退货数量] [numeric](18, 6) DEFAULT (0),
	[出库日期] [datetime],
	[到期日期] [datetime],
	[销售员] [varchar] (10),
	[仓库] [varchar] (10),
	[货位] [varchar] (10),
	[批号] [numeric](18, 6))

INSERT INTO #销售出库单明细表(销售单号,行,客户编码,物料编码,计量单位,
	出库数量,出库日期,到期日期,销售员,仓库,货位,批号)
select 销售单号,行,客户编码,物料编码,计量单位,
	出库数量,出库日期,到期日期,销售员,仓库,货位,批号
from 销售出库单明细表  WHERE 	销售单号>=@CO_to and 销售单号<=@CO_fr

SELECT *FROM #销售出库单明细表 WHERE 退货数量<0  OR  借项退货>0