Group duplicate Sql Server lines

Question

I created the query where I have a table Products and another stock (1:N) need to add the stock of each product has in the stock table, I made the following query:

select DISTINCT p.ID,IsNull(p.CodigoBarra, '') As 
CodBarra,IsNull(p.CodigoAlternativo, '') As 
CodAlt,p.Descricao,p.DescricaoAlternativa,f.Descricao as Fabricante, 
sum(est.EstoqueAtual) as EstoqueAtual, COUNT(est.EstoqueAtual) as 
QtdEsnderecosEstoque from produto p
inner join Fabricante f on f.ID = p.FabricanteID
left join EstoqueLoteLocalizacao est on est.ProdutoId = p.ID
where p.DataExclusao is null and p.EmpresaID = 3
group by p.ID,p.CodigoBarra,p.CodigoAlternativo,p.Descricao,p.DescricaoAlternativa,f.Descricao, est.EstoqueAtual

This Query returns me the following:

What I need is that instead of him giving me the 2 records, he group and the current stock there is added 4000 - -40 and me display in 1 record only the value of 3960

Answer 1

When you use grouper function (such as SUM), it will take into account all lines that are differentiated by GROUP BY.

In case, your GROUP BY included in its column clause est.EstoqueAtual. If you remove this column from GROUP BY, he will group it and it will be added as desired.