应收发票_proc.sql

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

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='应收发票_PROC' AND TYPE='P')
DROP PROC 应收发票_PROC
GO
CREATE PROC  应收发票_PROC
@CUST_TO VARCHAR(10),
@CUST_FR VARCHAR(10)
AS
CREATE TABLE [#销售发票]
 (
	[销售单号] [int] ,
	[客户码] [varchar] (10),
	[上次发票号] [varchar] (30) ,
	[上次发票日期] [datetime],
	[本次发票号] [varchar] (30),
	[本次发票日期] [datetime],
	[增值税金额] [numeric](18, 6)  DEFAULT (0) ,
	[发票金额] [numeric](18, 6)  DEFAULT (0) ,
	[已分配发票金额] [numeric](18, 6)  DEFAULT (0),
	[已分配增值税] [numeric](18, 6)  DEFAULT (0),
	[剩余发票金额] [numeric](18, 6)  DEFAULT (0),
	[剩余增值税金额] [numeric](18, 6)  DEFAULT (0))
	
INSERT INTO #销售发票 SELECT* FROM 销售发票
WHERE 客户码>=@CUST_TO AND 客户码<=@CUST_FR
SELECT *FROM #销售发票

-- EXEC 应收发票_PROC 'C01','C01'