本系统为企业进存销管理系统

if exists (select name from sysobjects where name='供应商发票明细_采购单_PROC' and type='P')
drop PROC 供应商发票明细_采购单_PROC
go
create PROC 供应商发票明细_采购单_PROC
@VEND_TO VARCHAR(10),
@VEND_fr VARCHAR(10)
as 
CREATE TABLE [#供应商发票明细] (
	[采购单号] [int],
	[行] [int],
	[入库日期] [datetime],
	[供应商编码] [varchar] (10),
	[物料编码] [varchar] (30),
	[货币编码] [varchar] (10),
	[计量单位] [varchar] (10),
	[增值税额]  [numeric](18, 6)  DEFAULT (0),
	[发票数量] [numeric](18, 0)DEFAULT (0),
	[仓库] [varchar] (10) ,
	[货位] [varchar] (10) ,
	[批号] [varchar] (15) ,
	[拒收原因] [varchar] (10),
	[发票金额]  [numeric](18, 0)  DEFAULT (0),
	[发票单价] [numeric](18, 0)  DEFAULT (0)) 

INSERT INTO #供应商发票明细(采购单号,行,入库日期,供应商编码,物料编码,货币编码,计量单位,增值税额,发票数量,
仓库,货位,批号,拒收原因,发票金额,发票单价)
SELECT 采购单号,行,入库日期,供应商编码,物料编码,货币编码,计量单位,增值税额,发票数量,
仓库,货位,批号,拒收原因,发票金额,发票单价
FROM 采购入库单明细表
WHERE 供应商编码>=@VEND_to and 供应商编码<=@VEND_fr
select *from #供应商发票明细

-- EXEC 供应商发票明细_供应商__PROC 1,1