From: hvandenberg@xs4all.nl   
      
   On 25-04-2011 15:31, Erland Sommarskog wrote:   
   > Erland Sommarskog (esquel@sommarskog.se) writes:   
   >> Thanks for the sample data!   
   >>   
   >> I see that I had forgot the join condition on EmpId - without the query is   
   >> kind of meaningless.   
   >>   
   >> The principle is simple: number the rows, and then make a self-join on   
   >> the row number with the next number.   
   > JOIN   numbered b ON b.rowno = a.rowno +1   
   >                   AND b.EmpId = a.EmpId   
      
   Yes, that was what I had in mind as well. Just didn't manage to put it   
   all together.   
      
   Thanks, Henk   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)