IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='貨位主文件_PROC' AND TYPE='P')
DROP PROC 貨位主文件_PROC
GO
create procedure  貨位主文件_PROC
@LOC_to varchar(10),
@LOC_fr varchar(10)
as

CREATE TABLE [#貨位主文件] 
(
	[貨位編碼] [varchar] (10),
	[貨位描述] [varchar] (20) ,
	[永久] [char] (1))

insert into #貨位主文件 select * from 貨位主文件 
where 貨位編碼>=@LOC_TO AND 貨位編碼<=@LOC_FR
SELECT* FROM #貨位主文件