C.Peachment <[EMAIL PROTECTED]> wrote:
What is wrong with using:select EventID, EventDate, EventTime order by EventDate, EventTime group by EventDate;
Remove GROUP BY clause - it would result in just one record for every distinct EventDate value, which is clearly not what the OP wants.
Igor Tandetnik
