I have a little query that shows the page views per month but it always adds .00 at the end. How do I get rid of that?

-- Page Views per Month
select convert(varchar,cast(count(*) as money),1) as 'Page views'
from SiteLog
where Datediff(day, datetime, GETDATE()) <=30

Ok, first let me preface this answer by saying that it is not a good idea to try and format strings with SQL. The DB layer is not meant to do that type of processing, so it will not perform as well as doing it in the presentation or business logic layer.

If you want commas without the decimal you can do it like this:

Select SubString(convert(varchar,cast(count(*) as money),1),0,Len(convert(varchar,cast(count(*) as money),1))-2)  AS 'Page Views'
from SiteLog
where Datediff(day, GameDate, GETDATE()) <=30