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),
        出庫類型 CHAR(1),
	[批號] [varchar] (15) ,
	[原因碼] [varchar] (10),
	[處理日期] [datetime],
	[單據號] [varchar] (20),
	[倉庫] [varchar] (10),
	[出庫數量] [numeric](18, 6)  DEFAULT (0))
	
	
insert into #出庫(物料編碼,出庫類型,出庫數量,貨位編碼,批號,原因碼,處理日期,單據號) 
select 物料編碼,出庫類型,出庫數量,貨位編碼,批號,原因碼,處理日期,單據號 from 出庫
where 物料編碼>=@ITEM_to AND 物料編碼<=@ITEM_fr
SELECT* FROM #出庫