IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='應收發票_PROC' AND TYPE='P')
DROP PROC 應收發票_PROC
GO
CREATE PROC  應收發票_PROC
@CUST_TO VARCHAR(10),
@CUST_FR VARCHAR(10)
AS
CREATE TABLE [#銷售發票]
 (
	[銷售單號] [int] ,
	[客戶碼] [varchar] (10),
	[上次發票號] [varchar] (30) ,
	[上次發票日期] [datetime],
	[本次發票號] [varchar] (30),
	[本次發票日期] [datetime],
	[增值稅金額] [numeric](18, 6)  DEFAULT (0) ,
	[發票金額] [numeric](18, 6)  DEFAULT (0) ,
	[已分配發票金額] [numeric](18, 6)  DEFAULT (0),
	[已分配增值稅] [numeric](18, 6)  DEFAULT (0),
	[剩余發票金額] [numeric](18, 6)  DEFAULT (0),
	[剩余增值稅金額] [numeric](18, 6)  DEFAULT (0))
	
INSERT INTO #銷售發票 SELECT* FROM 銷售發票
WHERE 客戶碼>=@CUST_TO AND 客戶碼<=@CUST_FR
SELECT *FROM #銷售發票

-- EXEC 應收發票_PROC 'C01','C01'