I am fairly certain what I want to accomplish but I am not certain how to set it up.
I have a Table where several records might have duplicate ItemName values. When that happens, I want to add up all of the corresponding Qty values on the records. Here is my effort at a query to do this:
select ItemName, Sum(Qty) as 'Summed Qty' from ITEM group by ItemName
Is this the best way to achieve my needed result?