Amour22015
asked on
SQL Server 2012 r2 - Sum totals
Hi Experts,
I have this part of query:
But this gives a laundry list of total.
Like:
I need something like:
Sum( Count(*)) as Total
I need it to sum up the total per each Category
So Above baseline would have like:
Above baseline 82100
Please help and thanks...
I have this part of query:
Select Distinct
AB.Scandate,
AB.Category,
AB.Plugin,
AB.IPLong,
Count(*) as Total
From #tmpbaseline AB -- Above Base line
Group By AB.Scandate,
AB.Category,
AB.Plugin,
AB.IPLong
But this gives a laundry list of total.
Like:
I need something like:
Sum( Count(*)) as Total
I need it to sum up the total per each Category
So Above baseline would have like:
Above baseline 82100
Please help and thanks...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER