That's what I would do and this data is static, but there's a couple other columns and I need to be able to slice it by those.. so basically this...

Here's the query plan. I don't think it adds much to what I've indicated, but you're the experts. See anything here? Thanks again

Verified:

select sum(weight) as w,count(*) as theCount, hit,cell,MetricID,adServerCampaignId

into #tmp

from adServerRespondentReport (NOLOCK)

group by hit,cell,MetricID,adServerCampaignId

(21349 row(s) affected)

also takes close to 30 seconds.

So there's no way to improve the performance of this...