IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='出庫單打印_PROC' AND TYPE='P')
DROP PROC 出庫單打印_PROC
GO
CREATE PROC  出庫單打印_PROC
@CO INT

AS
CREATE TABLE [#出庫單打印] (
	[銷售單號] [int] NULL ,
	[行] [int] NULL ,
	[客戶編碼] [varchar] (10) ,
	[物料編碼] [varchar] (30) ,
	[計量單位] [varchar] (10)  ,
	[出庫數量] [numeric](18, 6) DEFAULT (0),
	[退貨數量] [numeric](18, 6)DEFAULT (0),
	[出庫日期] [datetime],
	[銷售員] [varchar] (10),
	[倉庫] [varchar] (10),
	[貨位] [varchar] (10) ,
	[批號] VARCHAR(15))
INSERT INTO #出庫單打印(銷售單號,行,客戶編碼,物料編碼,計量單位,
出庫數量,退貨數量,出庫日期,銷售員,倉庫,貨位,批號)
SELECT 銷售單號,行,客戶編碼,物料編碼,計量單位,
出庫數量,退貨數量,出庫日期,銷售員,倉庫,貨位,批號
FROM 銷售出庫單明細表
WHERE 銷售單號=@CO

SELECT *FROM #出庫單打印