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