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] (30),
	[倉庫編碼] [varchar] (10),
	[安全庫存量] [numeric](18, 6),
	[上次盤點時間] [datetime])

insert into #物料與倉庫 select * from 物料與倉庫  where 物料編碼>=@ITEM_TO AND 物料編碼<=@ITEM_FR
SELECT* FROM #物料與倉庫