IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='庫存調整_原因_PROC' AND TYPE='P')
DROP PROC 庫存調整_原因_PROC
GO
create procedure 庫存調整_原因_PROC
@res_to varchar (10),
@res_fr varchar (10)
as


	CREATE TABLE [#庫存調整] 
       (
	[物料編碼] [varchar] (30),
	[計量單位] [varchar] (10),
	[調整數量] [numeric](18, 6),
	[倉庫] [varchar] (10),
	[貨位編碼] [varchar] (10),
	[批號] [varchar] (15),
	[原因碼] [varchar] (10),
	[處理日期] [datetime] )
	
insert into #庫存調整(物料編碼,計量單位,調整數量,倉庫,貨位編碼,批號,原因碼,處理日期) 
select 物料編碼,計量單位,調整數量,倉庫,貨位編碼,批號,原因碼,處理日期 
from 庫存調整 where 原因碼>=@res_to AND 原因碼<=@res_fr
SELECT* FROM #庫存調整