Select		        p.pagename, 
			Count(t.userid) as PageCount, 
			SUM(t.renderTime) as totalRender 

from		Pageindex p, 
		PageTrack t 

Where		t.pageid = p.pageid 
		AND Date LIKE '%Dec%' 
		AND Date Like '%2009%' 	

Group by	p.pagename 

Order by PageCount desc 

create table #t (a int, b int);

insert #t
select 1, 1 union all
select 1, 1 union all
select 1, 1 union all
select 2, 1 union all
select 2, null union all
select 2, 1

select a, sum(b)
from	#t
group by
	a

drop table #t

quote:

---

Originally posted by crugerenator

got ya, used SUM(ISNULL(column,0)). worked like a charm... only now I'm getting this error:

Arithmetic overflow error converting expression to data type int.

---