Lee Jenkins wrote:

> Very shrewd way of tackling the problem though

I really can not claim the credit...Jo Celko is a bit of an SQL genius (
he even gets a mention in Helens book in the further reading section so
he must be kinda good)

> ...I'm
> look forward to timing it.

Let us know how it performs in comparison to your firs method as I've
often wondered how the two approaches compare..