请问楼主,存储过程怎么写呀.能不能给个例子呀.谢谢!!

CREATE PROCEDURE [材料现在库存A] AS
SELECT DISTINCT
TOP 100 PERCENT dbo.原材料前期结存.材料名称规格,
dbo.原材料前期结存.前期结存数量,
dbo.入库材料数量汇总.入库数量 AS 入库数量汇总,
dbo.材料出库1汇总.出库数量1 AS 出库数量1汇总,
dbo.材料出库2汇总.出库数量2 AS 出库数量2汇总
FROM dbo.原材料前期结存 LEFT OUTER JOIN
dbo.材料出库1汇总 ON
dbo.原材料前期结存.材料名称规格 = dbo.材料出库1汇总.材料名称规格1 LEFT OUTER JOIN
dbo.材料出库2汇总 ON
dbo.原材料前期结存.材料名称规格 = dbo.材料出库2汇总.材料名称规格2 LEFT OUTER JOIN
dbo.入库材料数量汇总 ON
dbo.原材料前期结存.材料名称规格 = dbo.入库材料数量汇总.材料名称规格
GO