i'm trying to create a simple report to show daily log on.
Query on my SQL Server is : Select distinct ( fullname ) , eventdatetime from log where eventdatetime > '02-18-2004'.
based upon my user is logging many times a day , i would like to know how can i only show the first or the last time he logged.
Thanks in advance.