IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='物料銷售成本_PROC' AND TYPE='P')
DROP PROC 物料銷售成本_PROC
GO
CREATE PROC  物料銷售成本_PROC
@CO_TO INT,
@CO_FR INT
AS

CREATE TABLE [#銷售成本] (
	[銷售單號] [int] ,
	[行] [int]  ,
	[客戶編碼] [varchar] (10) ,
	[物料編碼] [varchar] (30) ,
	[計量單位] [varchar] (10),
	[出庫數量] [numeric](18, 6)DEFAULT(0.00) ,
    [材料成本] [numeric](18, 6) DEFAULT(0.00) ,
	[人工] [numeric](18, 6) DEFAULT(0.00) ,
	[制造] [numeric](18, 6) DEFAULT(0.00) ,
    [單位材料] AS 材料成本/出庫數量,
        [單位人工] AS 人工/出庫數量,
        [單位制造] AS 制造/出庫數量)

INSERT INTO #銷售成本 (銷售單號,行,客戶編碼,物料編碼,計量單位,出庫數量,材料成本,人工,制造)
SELECT 銷售單號,行,客戶編碼,物料編碼,計量單位,出庫數量,材料成本,人工,制造 
FROM 銷售出庫單明細表 WHERE 銷售單號>=@CO_TO  AND 銷售單號<=@CO_FR
SELECT *FROM #銷售成本