if exists(select name from sysobjects where name='物料主文件_PROC' and type= 'p')
drop PROC 物料主文件_PROC
GO 
CREATE PROC 物料主文件_PROC
@從物料 VARCHAR(30),
@到物料 VARCHAR(30)
AS


CREATE TABLE [#物料主文件_基本] (
	[物料編碼] [varchar] (30),
	[物料描述] [varchar] (50),
	[計量單位編碼] [varchar] (10),
	[來源] [char] (1),
	[分類碼] [varchar] (10),
	[重量] [numeric](18, 6),
	[采購員] [varchar] (10),
	[顏色] [varchar] (20),
	[圖號] [varchar] (30),
	[版本號跟蹤] [char] (1)  DEFAULT (0),
	[銷售員] [varchar] (10),
	[銷售價格] [numeric](18, 6)  DEFAULT (0.00),
	[批發價格] [numeric](18, 6)  DEFAULT (0.00),
	[稅碼] [varchar] (10),
	[存儲期限_天] [numeric](18, 6) NULL ,
	[ABC分析碼] [char] (1)   DEFAULT (2),
	[狀態] [char] (1)DEFAULT (0))

INSERT INTO #物料主文件_基本 SELECT * FROM 物料主文件_基本 WHERE 物料編碼>=@從物料 AND 物料編碼<=@到物料
SELECT *FROM #物料主文件_基本