if exists (select name from sysobjects where name='記賬憑證_編碼_PROC' and type='P')
drop PROC 記賬憑證_編碼_PROC
go
create PROC 記賬憑證_編碼_PROC
@vou_to int,
@vou_fr int
as
CREATE TABLE [#記賬憑證] (
	[憑證號] [int] ,
	[供應商編碼] [varchar] (10),
	[采購單號] [int],
	[分配日期] [datetime] ,
	[發票號碼] [varchar] (20),
	[發票日期] [datetime],
	[增值稅碼] [varchar] (10),
	[增值稅率] [numeric](18, 6),
	[到期天數] [numeric](18, 6),
	[到期日期] [datetime],
	[注釋] [text],
	[貨幣] [varchar] (10),
	[材料金額] [numeric](18, 6) DEFAULT (0),
	[發票金額] [numeric](18, 0) DEFAULT (0),
	[增值稅額] [numeric](18, 6)DEFAULT (0)) 

INSERT INTO #記賬憑證 SELECT * from 記賬憑證 where 憑證號>=@vou_to and 憑證號<=@vou_fr
select *from  #記賬憑證
--EXEC 記賬憑證_編碼_PROC