if exists (select name from sysobjects where name='明細庫存表_PROC' and type='P')
drop PROC 明細庫存表_PROC
go
create PROC 明細庫存表_PROC
@ITEM_TO VARCHAR(30),
@ITEM_FR VARCHAR(30),
@年_TO INT,
@年_FR INT,
@月_TO INT,
@月_FR INT
AS
CREATE TABLE [#明細庫存表] (
	[KEY_ID] [int],
	[物料編碼] [varchar] (30),
	[物料描述] [varchar] (50),
	[年] [int],
	[月] [int],
	[月初結存數(shù)量] [numeric](18, 0)  DEFAULT (0),
	[月初材料成本] [numeric](18, 0)  DEFAULT (0),
	[月初人工成本] [numeric](18, 0) DEFAULT (0),
	[月初制造費用] [numeric](18, 0)  DEFAULT (0),
	[入庫累計數(shù)量] [numeric](18, 6)  DEFAULT (0),
	[入庫累計材料成本] [numeric](18, 6)  DEFAULT (0),
	[入庫累計人工成本] [numeric](18, 6)  DEFAULT (0),
	[入庫累計制造費用] [numeric](18, 6)  DEFAULT (0),
	[出庫累計數(shù)量] [numeric](18, 6)  DEFAULT (0),
	[出庫累計材料成本] [numeric](18, 6) DEFAULT (0),
	[出庫累計人工成本] [numeric](18, 6) DEFAULT (0),
	[出庫累計制造費用] [numeric](18, 6) DEFAULT (0),
	[月末結存數(shù)量][numeric](18, 6) DEFAULT (0),
	[月末材料成本] [numeric](18, 6) DEFAULT (0),
	[月末人工成本][numeric](18, 6) DEFAULT (0),
	[月末制造費用] [numeric](18, 6) DEFAULT (0))

INSERT INTO #明細庫存表 SELECT *FROM 明細庫存表
WHERE (物料編碼>=@ITEM_TO AND 物料編碼<=@ITEM_FR) 
AND (年>=@年_TO AND 年<=@年_FR ) AND (月>=@月_TO AND 月<=@月_FR)
SELECT *FROM #明細庫存表



-- EXEC 明細庫存表_PROC '電腦','電腦',2004,2004,1,1