IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='出庫(kù)_單據(jù)號(hào)_PROC' AND TYPE='P')
DROP PROC 出庫(kù)_單據(jù)號(hào)_PROC
GO
create procedure 出庫(kù)_單據(jù)號(hào)_PROC
@bill_to int,
@bill_fr int
as

CREATE TABLE [#出庫(kù)]
 ([物料編碼] [varchar] (30),
	[貨位編碼] [varchar] (10),
        出庫(kù)類型 CHAR(1),
	[批號(hào)] [varchar] (15) ,
	[原因碼] [varchar] (10),
	[處理日期] [datetime],
	[單據(jù)號(hào)] [varchar] (20),
	[倉(cāng)庫(kù)] [varchar] (10),
	[出庫(kù)數(shù)量] [numeric](18, 6)  DEFAULT (0))
	
	
insert into #出庫(kù)(物料編碼,出庫(kù)類型,出庫(kù)數(shù)量,貨位編碼,批號(hào),原因碼,處理日期,單據(jù)號(hào)) 
select 物料編碼,出庫(kù)類型,出庫(kù)數(shù)量,貨位編碼,批號(hào),原因碼,處理日期,單據(jù)號(hào) from 出庫(kù)
where 單據(jù)號(hào)>=@bill_to AND 單據(jù)號(hào)<=@bill_fr
SELECT* FROM #出庫(kù)