Summing rows to combine them

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26986 More actions · Answer 1

Another way

with cte as (

select [State], County, Sex, class,

case when Agegroup in ('15-17 yrs', '18-20 yrs', '21-24 yrs') then '15-24 yrs' else Agegroup end AS [Agegroup],

[total]

from #temp)

select [State], County, Sex, class, Agegroup, sum(total) AS [total]

from cte

group by [State], County, Sex, class, Agegroup

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

matak SSCrazy Points: 2734 More actions · Answer 2

SSCrazy

Points: 2734

June 4, 2013 at 1:40 am

Thanks - this is a lot nicer than what i had.