供应商发票_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
@po_to int,
@po_fr int
AS
CREATE TABLE [#供应商发票] (
	[采购单号] [int],
	[供应商码] [varchar] (10),
	[上次发票号] [varchar] (30),
	[上次发票日期] [datetime],
	[本次发票号] [varchar] (30),
	[本次发票日期] [datetime],
	[增值税金额] [numeric](18, 6),
	[材料金额] [numeric](18, 6),
	[已分配材料金额] [numeric](18, 6)  DEFAULT (0.00000),
	[已分配增值税] [numeric](18, 6)  DEFAULT (0.0000),
	[剩余材料金额]  [numeric](18, 6) DEFAULT (0.000000),
	[剩余增值税金额] [numeric](18, 6) DEFAULT (0.000000))
	
INSERT INTO #供应商发票 SELECT * FROM 供应商发票
WHERE 采购单号>=@po_to AND 采购单号<=@po_fr 
SELECT  *FROM #供应商发票
-- EXEC 供应商发票_PROC 1,1