if exists(select name from sysobjects  where name='供應商主文件_proc' AND TYPE='P' )
DROP PROC 供應商主文件_proc
go
CREATE PROC 供應商主文件_proc
@VEND_TO VARCHAR(10),
@VEND_FT VARCHAR(10)
AS

 CREATE TABLE [#供應商主文件] (
	[供應商編碼] [varchar] (10),
	[供應商描述] [varchar] (50),
	[供應商地址] [varchar] (130),
	[城市] [varchar] (10),
	[國家] [varchar] (20),
	[縣] [varchar] (20),
	[郵編] [varchar] (20),
	[郵箱] [varchar] (30),
	[類型] [varchar] (20),
	[倉庫] [varchar] (10),
	[發貨途徑] [varchar] (10),
	[采購員] [varchar] (10),
	[銀行碼] [varchar] (10),
	[貨幣] [varchar] (10),
	[賬單到地址] [varchar] (10),
	[賬單聯系人] [varchar] (10),
	[稅碼] [varchar] (10),
	[付款暫停] [char] (1),
	[暫停原因碼] [varchar] (10),
	[暫停付款日期] [datetime])

INSERT INTO #供應商主文件 SELECT *FROM 供應商主文件
WHERE 供應商編碼>=@VEND_TO AND 供應商編碼<=@VEND_TO
SELECT *FROM #供應商主文件