I would use a stored procedure or function for this. You order your results first by employee and then event date and finally even time. Then you create a new result set from the first and return that.That would probably be the most straight forward approach.
You could also try doing some thing l
what about putting a limit of 1 on your select statement, so you will just get the first event greater then the initial date for the employee?On 6/18/06, Sim Zacks
<[EMAIL PROTECTED]> wrote:I am having brain freeze right now and was hoping someone could help me
with a (fairly) simple query.I need
I am having brain freeze right now and was hoping someone could help me
with a (fairly) simple query.
I need to join on the next row in a similar table with specific criteria.
I have a table with events per employee.
I need to have a query that gives per employee each event and the event
after
