|
-
Mar 20th, 2002, 12:33 PM
#1
Thread Starter
Hyperactive Member
ASP hit count?
SELECT Count(Tracking.IP) AS CountOfIP, DatePart("m",[date]) & "-" & DatePart("d",[date]) & "-" & DatePart("yyyy",[date]) AS Expr1
FROM Tracking
GROUP BY DatePart("m",[date]) & "-" & DatePart("d",[date]) & "-" & DatePart("yyyy",[date]);
The above SQL statement works fine for what I am trying to except I only want to count unique IP addresses for each day.
Unique won't work because each record is already unique. Any ideas?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|