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 [#應收賬款明細賬] (
	[客戶編碼] [varchar] (10)  ,
	[銷售單] [int]  ,
	[貨幣] [varchar] (10) ,
	[憑證號] [int],
	[發票號碼] [varchar] (20)  ,
	[發票日期] [datetime] ,
	[借方金額] [numeric](18, 6),
	[貸方金額] [numeric](18, 6),
	[余額] [numeric](18, 6))
INSERT INTO #應收賬款明細賬 SELECT* FROM 應收賬款明細賬
WHERE 客戶編碼>=@CUST_TO AND 客戶編碼<=@CUST_FR

SELECT *FROM #應收賬款明細賬