I agree its important to test. I performed a similar test with a variable table and a temp table. The variable table was about 20% slower than using a temp table. If...

Try this SQL:

select ownerid, SUM(case when status='yes' then 0

        else nocnt end) as nocnt

from #tblA

where status IN ('no','yes')

group by ownerid