销售过期订单_proc.sql

来自「SQL server 进销存软件数据库设计。大家积极下载」· SQL 代码 · 共 27 行

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

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