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))
| Location |
Item1 |
Item2 |
| Delhi |
10 |
NULL |
| Haryana |
26 |
2 |
Thanks