Thomas,

> I usually solve this kind of problem with recusive CTEs providing a counter for
> the records returned, thus a "simple" select statement can nicely filter on
> this kind of property without row numbers functionality.

Can you provide an example, please.

I, for one, can't imagine how a CTE could be used for such a purpose.


Sean