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),
	[倉庫] [varchar] (10),
	[貨位編碼] [varchar] (10),
	[批號] [varchar] (15),
	[原因碼] [varchar] (10),
	[處理日期] [datetime] )
	
insert into #庫存調整(物料編碼,計量單位,調整數量,倉庫,貨位編碼,批號,原因碼,處理日期) 
select 物料編碼,計量單位,調整數量,倉庫,貨位編碼,批號,原因碼,處理日期 
from 庫存調整 where 物料編碼>=@item_to AND 物料編碼<=@item_fr
SELECT* FROM #庫存調整