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)  ,
	入庫類型 CHAR(1),
        [入庫數量] [numeric](18, 6)  ,
	[貨位編碼] [varchar] (10)  ,
	[批號] [varchar] (15) ,
	[原因碼] [varchar] (10)  ,
	[處理日期] [datetime]  ,
	[單據號] [int] )


insert into #入庫(物料編碼,入庫類型,入庫數量,貨位編碼,批號,原因碼,處理日期,單據號) 
select 物料編碼,入庫類型,入庫數量,貨位編碼,批號,原因碼,處理日期,單據號 from 入庫
where 物料編碼>=@ITEM_TO AND 物料編碼<=@ITEM_FR
SELECT* FROM #入庫