本系统为企业进存销管理系统

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),
	[分配日期] [datetime],
	[销售订单] [int] ,
	[发票号码] [varchar] (20) ,
	[发票日期] [datetime],
	[增值税码] [varchar] (10) ,
	[增值税率] [numeric](18, 6) ,
	[到期天数] [numeric](18, 6) ,
	[到期日期] [datetime] ,
	[注释] [text] ,
	[货币] [varchar] (10) ,
	[发票金额] [numeric](18, 6)  ,
	[增值税金额] [numeric](18, 6))
INSERT INTO #销售记账凭证 SELECT * FROM 销售记账凭证
WHERE 客户编码>=@CUST_TO AND 客户编码<=@CUST_FR
SELECT *FROM #销售记账凭证
-- EXEC 销售凭证_客户_PROC 'C01','C01'