SELECT ip_address, visit_date, count(ip_address) as visits
FROM visit_log
GROUP BY visit_date, ip_address, visited_page
HAVING visited_page = 'index.cfm'
ORDER BY ip_address, visit_date
You could QoQ to get sum(visits) group by visit_date. How you would go about determining visits that are at least 15 minutes...dunno.
Sorry...
~Dina
----- Original Message -----
From: Jeff Small
To: SQL
Sent: Monday, April 19, 2004 10:28 AM
Subject: Re: Help me thru this...
> If you have control over your db structure, it would be best to have
"start_time" and "end_time" fields in that table.
>
> ~Dina
What if we don't? What if it's just a raw IIS logfile? date and time stamp
only? I think that's the entire problem we're facing. How do we achieve the
results we're looking for with what we're given?
Any help pointing in ANY direction is appreciated.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
