Hello Everyone,

I have set up a table that contains the following fields
1. DateAdded
2. PageName

And I am trying to write a query that will pull back records for me where I
can count up the number of times a page or pages were hit on the website for
each day. So if my records were like this

DateAdded                           PageName
1/1/2006                                /index.htm
1/1/2006                               /index.htm
1/1/2006                               /contact/index.htm
1/2/2006                               /index.htm
1/2/2006                                /contact/index.htm
1/2/2006                                /contact/thankyou.htm

that after query has run I would have something like this
Date        Page             Number of Visits
1/1/2006 /index.htm                2
1/1/2006 /contact/index.htm    1
1/2/2006  /index.htm                1
1/2/2006  /contact/index.htm   1
1/2/2006  /contact/thankyou.htm 1

I am trying to keep this in sql, but if this this is not possible then I can
always do this in the code on my asp.net page, any help on this would be
appreciated.