Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JasonErdahl
Starting Member
3 Posts |
 Posted - 2001-05-24 : 18:18:55
|
| Hello -I'm trying to compile my web log files so that I know how many Page Views and Visitor Sessions I received in a given day. Right now I have (2) fields in my database: IP address and URL.I know that if I do a count of the number of times an URL appears it will give me the page views and the number of times an URL and IP appears will give me the visitor sessions.Any ideas on how I could do that in DTS? I'm thinking some kind of running total, but I start out with 1 Gig log files and I need it to be fairly efficient.Thanks,Jason |
|
|
|
|
|
Running Totals Question