Hi
I have below data . I want to display Totals. Items are dynamic. It can be Item1 , Item2 , Item3 , Item4 & so on.
Temp Table
CREATE TABLE #temp(Location nvarchar(max), Quantity numeric(19,6),itemName nvarchar(50))
Thanks