if exists (select name from sysobjects where name='供應(yīng)商發(fā)票明細_供應(yīng)商_PROC' and type='P')
drop PROC 供應(yīng)商發(fā)票明細_供應(yīng)商_PROC
go
create PROC 供應(yīng)商發(fā)票明細_供應(yīng)商_PROC
@VEND_TO VARCHAR(10),
@VEND_fr VARCHAR(10)
as 
CREATE TABLE [#供應(yīng)商發(fā)票明細] (
	[采購單號] [int],
	[行] [int],
	[入庫日期] [datetime],
	[供應(yīng)商編碼] [varchar] (10),
	[物料編碼] [varchar] (30),
	[貨幣編碼] [varchar] (10),
	[計量單位] [varchar] (10),
	[增值稅額]  [numeric](18, 6)  DEFAULT (0),
	[發(fā)票數(shù)量] [numeric](18, 0)DEFAULT (0),
	[倉庫] [varchar] (10) ,
	[貨位] [varchar] (10) ,
	[批號] [varchar] (15) ,
	[拒收原因] [varchar] (10),
	[發(fā)票金額]  [numeric](18, 0)  DEFAULT (0),
	[發(fā)票單價] [numeric](18, 0)  DEFAULT (0)) 

INSERT INTO #供應(yīng)商發(fā)票明細(采購單號,行,入庫日期,供應(yīng)商編碼,物料編碼,貨幣編碼,計量單位,增值稅額,發(fā)票數(shù)量,
倉庫,貨位,批號,拒收原因,發(fā)票金額,發(fā)票單價)
SELECT 采購單號,行,入庫日期,供應(yīng)商編碼,物料編碼,貨幣編碼,計量單位,增值稅額,發(fā)票數(shù)量,
倉庫,貨位,批號,拒收原因,發(fā)票金額,發(fā)票單價
FROM 采購入庫單明細表
WHERE 供應(yīng)商編碼>=@VEND_to and 供應(yīng)商編碼<=@VEND_fr
select *from #供應(yīng)商發(fā)票明細

-- EXEC 供應(yīng)商發(fā)票明細_供應(yīng)商__PROC 1,1