if exists (select name from sysobjects where name='供應(yīng)商發(fā)票_PROC' and type='P')
drop PROC 供應(yīng)商發(fā)票_PROC
go
create PROC 供應(yīng)商發(fā)票_PROC
@po_to int,
@po_fr int
AS
CREATE TABLE [#供應(yīng)商發(fā)票] (
	[采購單號] [int],
	[供應(yīng)商碼] [varchar] (10),
	[上次發(fā)票號] [varchar] (30),
	[上次發(fā)票日期] [datetime],
	[本次發(fā)票號] [varchar] (30),
	[本次發(fā)票日期] [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 #供應(yīng)商發(fā)票 SELECT * FROM 供應(yīng)商發(fā)票
WHERE 采購單號>=@po_to AND 采購單號<=@po_fr 
SELECT  *FROM #供應(yīng)商發(fā)票
-- EXEC 供應(yīng)商發(fā)票_PROC 1,1