select rtrim(PARTNUMBER) as [Part Number]
, sum(QSHIP) as [Qty]
where PARTNUMBER = '334S609'
and ADDED_DTE > DATEADD(M, -12, getdate())
group by PARTNUMBER, QSHIP
Part Number Qty
How do I get this to return one line with 25 as the Qty?