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.


s
"Gail Shaw" <initialsurname@sentech sa dot com> wrote in message 
news:480cfff3@news.povray.org...
>
> "Halbert" <hal### [at] gmailcom> wrote in message
> news:480cfb5d$1@news.povray.org...
>> If we have any SQL gurus out there (not mentioning any names, Gail :-)
>
> Hmmm, am I hearing things?
>
>> I
>> have a simple problem I with undoubtedly a simple answer.
>> I have a log table:
>>
>> Log_time | IP | Script_Name| Email | DK
>
> Ok. Think I understand. It's a little complex, but not really difficult.
> Do need some things clarifying.
>
> Say you have 3 rows with the same Email, different IP, different Log time
> and different script. (is that possible?)
> What log time, IP, script do you want returning? The ones that match the
> latest log-time? Oldest log time? Any one, doesn't matter?
>
> Oh, what DB engine? Oracle, My SQL, SQL Server, other? What version?
>
> If no one's helped by morning, I'll take a look, but it's 11pm here...
>
>

Post a reply to this message