这样的存储过程效率高吗?
wg168 2003-04-18 10:24:41 SELECT TOP 100 PERCENT ISNULL(a.BOM_FullID, '') AS BOM_FullID,
ISNULL(a.BOM_Level, '') AS BOM_Level, ISNULL(c.Pro_Id, '') AS Pro_Id,
ISNULL(c.Pro_Name, '') AS Pro_Name, a.BOM_Number, a.BOM_WasteRate,
a.BOM_Number1, a.BOM_SonNum, ISNULL(b.ProceID, '') AS ProceID,
ISNULL(b.ProceName, '') AS ProceName, ISNULL(f.Pro_Id, '') AS Pro_Id_R,
ISNULL(f.Pro_Name, '') AS Pro_Name_R, a.BOM_Number_R, a.BOM_WasteRate_R,
a.BOM_Number_R1, a.BOM_MadeBOMDate, ISNULL(d.ProceID, '') AS ProceID_R,
ISNULL(d.ProceName, '') AS ProceName_R, ISNULL(SUM(gg.P_Total)
/ SUM(gg.P_Number), 0) AS P_Price
FROM dbo.StorStatus gg RIGHT OUTER JOIN
dbo.Product c ON gg.P_FullId = c.Pro_FullId RIGHT OUTER JOIN
dbo.SC_BOM a ON c.Pro_FullId = a.BOM_ProFullID LEFT OUTER JOIN
dbo.Product f ON a.BOM_ProFullID_R = f.Pro_FullId LEFT OUTER JOIN
dbo.SC_WorkProce b ON a.BOM_WorkProceFullID_R = b.FullID LEFT OUTER JOIN
dbo.SC_WorkProce d ON a.BOM_WorkProceFullID = d.FullID
where BOM_FullID like @FirstBOMFullID +'%' and BOM_Deleted=0
GROUP BY a.BOM_Level, a.BOM_WasteRate, a.BOM_Number1, a.BOM_Number_R,
a.BOM_SonNum, a.BOM_Number_R1, a.BOM_WasteRate_R, a.BOM_MadeBOMDate,
b.ProceID, b.ProceName, d.ProceID, d.ProceName, f.Pro_Name, f.Pro_Id, c.Pro_Id,
c.Pro_Name, a.BOM_FullID, a.BOM_Number
ORDER BY a.BOM_FullID