Производственная БД

SELECT        dbo.tblGenPlan.KKS, dbo.tblGenPlan.GPName, SUM(ISNULL(dbo.tblDrawSpec.Kolvo, 0) * ISNULL(dbo.tblDrawSpec.VesEd, 0) / 1000) AS DrawWeight, SUM(ISNULL(dbo.tblDrawSpec.Kolvo, 0) * ISNULL(dbo.tblDrawSpec.VesEd, 0) 
                         / 1000 * ISNULL(dbo.tblPPData.TrMont, 0) * ISNULL(dbo.tblPPData.TrKoeff, 0)) + SUM(ISNULL(dbo.tblDrawSpec.KolvoIzg, 0) * ISNULL(dbo.tblDrawSpec.VesEd, 0) / 1000 * ISNULL(dbo.tblPPData.TrIzg, 0)) AS TrudAll, 
                         SUM(ISNULL(dbo.прОстатки_01.[Ост. монт.], 0) * ISNULL(dbo.tblDrawSpec.VesEd, 0) / 1000) AS VesOst, SUM(ISNULL(dbo.прОстатки_01.[Ост. монт.], 0) * ISNULL(dbo.tblDrawSpec.VesEd, 0) 
                         / 1000 * ISNULL(dbo.tblPPData.TrMont, 0) * ISNULL(dbo.tblPPData.TrKoeff, 0)) + SUM(ISNULL(dbo.прОстатки_01.[Ост. изг.], 0) * ISNULL(dbo.tblDrawSpec.VesEd, 0) / 1000 * ISNULL(dbo.tblPPData.TrIzg, 0)) AS TrudOst
FROM            dbo.tblGenPlan INNER JOIN
                         dbo.tblDraw ON dbo.tblGenPlan.ID_GenPlan = dbo.tblDraw.ID_GenPlan INNER JOIN
                         dbo.tblDrawSys ON dbo.tblDraw.ID_Draw = dbo.tblDrawSys.ID_Draw INNER JOIN
                         dbo.tblDrawSpec ON dbo.tblDrawSys.ID_DrawSys = dbo.tblDrawSpec.ID_DrawSys LEFT OUTER JOIN
                         dbo.прОстатки_01 ON dbo.tblDrawSpec.ID_DrawSpec = dbo.прОстатки_01.ID_DrawSpec LEFT OUTER JOIN
                         dbo.tblPPData ON dbo.tblDrawSpec.ID_DrawSpec = dbo.tblPPData.ID_DrawSpec
GROUP BY dbo.tblGenPlan.KKS, dbo.tblGenPlan.GPName, dbo.tblDraw.Stage, dbo.tblDraw.StageTEP
HAVING        (dbo.tblDraw.Stage = N'Основной этап') AND (dbo.tblGenPlan.KKS <> N'ZZZ') AND (dbo.tblDraw.StageTEP <> 0)