IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='應(yīng)收賬明細(xì)_客戶_PROC' AND TYPE='P')
DROP PROC 應(yīng)收賬明細(xì)_客戶_PROC
GO
create  PROC 應(yīng)收賬明細(xì)_客戶_PROC
@CUST_TO varchar(10),
@CUST_FR varchar(10)
AS 
CREATE TABLE [#應(yīng)收賬款明細(xì)賬] (
	[客戶編碼] [varchar] (10)  ,
	[銷售單] [int]  ,
	[貨幣] [varchar] (10) ,
	[憑證號] [int],
	[發(fā)票號碼] [varchar] (20)  ,
	[發(fā)票日期] [datetime] ,
	[借方金額] [numeric](18, 6),
	[貸方金額] [numeric](18, 6),
	[余額] [numeric](18, 6))
INSERT INTO #應(yīng)收賬款明細(xì)賬 SELECT* FROM 應(yīng)收賬款明細(xì)賬
WHERE 客戶編碼>=@CUST_TO AND 客戶編碼<=@CUST_FR

SELECT *FROM #應(yīng)收賬款明細(xì)賬