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
@CO_TO INT,
@CO_FR INT
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 銷售單>=@CO_TO AND 銷售單<=@CO_FR

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