Hello again guys.....how are you doing?
The query is working perfectly fine. I have implemented the query and tested it for a tree having sub trees till the eighth level.
Peter, i am still not very clear with the adding of the 0s to the TreeOrder string. Could you please tell me the logic behind doing so.....would love to know.
Dwain, I'm really sorry for the missing commas in the Insert statements........My mind was completely occupied with the query even when I was posting the sample data.....but u still beat me to it :-)
For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden