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),
	[客戶描述] [varchar] (50),
	[客戶地址] [varchar] (130),
	[城市] [varchar] (10),
	[國家] [varchar] (20),
	[縣] [varchar] (20),
	[電話] [varchar] (15),
	[郵編] [varchar] (10),
	[郵箱] [varchar] (30),
	[客戶類型] [varchar] (10),
	[信用限額] [numeric](18, 6) DEFAULT (0),
	[賬單聯系人] [varchar] (10),
	[銷售員] [varchar] (10),
	[賬單到地址] [varchar] (10),
	[發貨到地址] [varchar] (10),
	[銀行碼] [varchar] (10),
	[貨幣] [varchar] (10),
	[信用暫停] [char] (1),
	[暫停原因碼] [varchar] (10),
	[暫停日期] [datetime] )

INSERT INTO #客戶主文件 SELECT *FROM 客戶主文件
WHERE 客戶編碼>=@CUST_TO AND  客戶編碼<=@CUST_FR