I get the exact same value... maybe I was just being paranoid. Your method does make more sense to me though. I think Ill use it instead of mine. Thanks for your input.

Eric



>Would this work for you?

select avg(x.pageViews) as avgPageViewsPerDay
>	FROM (select top 95 percent count(*) as pageViews from hits
>		group by CONVERT(char(8), viewTime,112) AS ViewDate
>		order by pageviews asc ) x
>	JOIN (select top 95 percent count(*) as pageViews from hits
>			group by CONVERT(char(8), viewTime,112) AS ViewDate
>			order by pageviews desc ) y
>		ON x.ViewDate = y.ViewDate
>

>