IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='物料與貨位_PROC' AND TYPE='P')
DROP PROC 物料與貨位_PROC
GO
create procedure 物料與貨位_PROC
@item_to varchar(30),
@item_fr varchar(30)
as

CREATE TABLE [#物料與貨位對照表]
 (
	[倉庫編碼] [varchar] (10) ,
	[物料編碼] [varchar] (30) ,
	[貨位編碼] [varchar] (10),
	[批號] [varchar] (15)  ,
	[貨位等級] [int] ,
	[貨位存量] [numeric](18, 5) ,
	[永久貨位] [char] (1) )

insert into #物料與貨位對照表 select * from 物料與貨位對照表
 where 物料編碼>=@ITEM_TO AND 物料編碼<=@ITEM_FR
SELECT* FROM #物料與貨位對照表