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