|
 |
"Halbert" <hal### [at] gmail com> wrote in message
news:480d0145$1@news.povray.org...
> The script name will not be a variable. But the email could come from
> different IPs at different times. They want to have counts for the number
of
> times individuals used the getthere.asp script.
> We are using MS SQL Server (2000 in this case)
> Thanks again.
>
Ok, so say this is the input (as a comma-seperated list). What do you want
as results?
Logtime, IP, Email
2008/01/01 10:15, 10.2.45.56, me@here
2008/01/01 10:25, 10.2.45.56, me@here
2008/01/01 16:15, 10.2.78.156, me@here
2008/01/02 12:15, 10.2.15.74, me@here
2008/01/02 12:15, 10.2.15.74, me@here
2008/01/02 12:17, 10.2.15.74, me@here
2008/01/02 12:19, 10.2.15.74, me@here
2008/01/01 12:15, 10.5.25.34, you@somewhere
2008/01/01 13:15, 10.5.25.34, you@somewhere
2008/01/01 14:15, 10.5.25.34, you@somewhere
2008/01/01 18:15, 10.5.25.38, you@somewhere
Post a reply to this message
|
|
