> You're right, it's nothing like what you need. If you must do this
> partitioning, at least avoid SELECT FIRST n SKIP .etc and use a

cursor > instead:


Ah, ok...I didn't know that would be faster than using "first"

You're probably right; I shall do some restructuring on the
db..creating a result table is the first thing to do and i'm having an
idea how to get rid of some of the more complex links between tables...
thanx

martin