step:

procedura stocata SELECT dbo.Detalii.ProdusID, SUM(dbo.Detalii.Cantit) AS cantitE, dbo.BC.Predator FROM dbo.BC INNER JOIN dbo.Detalii ON dbo.BC.ID = dbo.Detalii.ID INNER JOIN dbo.NirD ON dbo.Detalii.ReceptieID = dbo.NirD.ID INNER JOIN dbo.NIR ON dbo.NirD.NirID = dbo.NIR.nirID WHERE (dbo.BC.AnulatDe IS NULL) GROUP BY dbo.Detalii.ProdusID, dbo.BC.Predator, dbo.NirD.NirID HAVING (dbo.Detalii.ProdusID = @produsID) AND (dbo.BC.Predator = @Predator) AND (dbo.NirD.NirID = @id) view ul SELECT SUM(dbo.Detalii.Cantit) AS Cantit, dbo.Detalii.ProdusID, dbo.Detalii.SarjaID, dbo.BC.ID, 0 AS Modif FROM dbo.Detalii INNER JOIN dbo.BC ON dbo.BC.ID = dbo.Detalii.ID GROUP BY dbo.Detalii.ProdusID, dbo.Detalii.SarjaID, dbo.BC.ID