Are you locked into that node / parentNode hierarchy model? It's not very efficient.
There are more than one ways of skinning a cat here, if you're in a position to drop that particular approach... That said, it's doable in one query on Oracle with CONNECT BY PRIOR. I think SQL Server 2005 has a similar construct (but 2000 does not). -- Adam --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
