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

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

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