if exists (select name from sysobjects where name='采購單打印_PROC' and type='P')
drop PROC 采購單打印_PROC
go
create PROC 采購單打印_PROC
@po int
AS
CREATE TABLE [#采購訂單明細表] (
	
	[采購單號] [int]  ,
	[供應商編碼] [varchar] (10) ,
        [行] [int]  ,
	[物料編碼] [varchar] (30)  ,
	[計量單位] [varchar] (10) ,
        [訂購數量] [numeric](18, 6)  ,
	[訂購日期] [datetime] ,
	[到期日期] [datetime] )
INSERT INTO #采購訂單明細表(采購單號,供應商編碼,行,物料編碼,計量單位,訂購數量,訂購日期,到期日期)
SELECT 采購單號,供應商編碼,行,物料編碼,計量單位,訂購數量,訂購日期,到期日期 FROM 采購訂單明細表 
WHERE 采購單號=@PO
SELECT *FROM #采購訂單明細表

-- EXEC 采購單打印_PROC 1