would you by chance be able to post that simple .net code for ftping here? I could use that right now... Thanks

I would just wrap your code in () and use it as a type of derived table and average the counts like this...

select MonthName, Dayname, Average(actualCount)

from

(

SELECT CreationDate,DATENAME(month, CreationDate) as...