Is there anyway to get a complex hierarychy of data in a single call using L Pro. For ex: Parent -> Child -> GrandChild -> GreatGrandChild I know there is a prefetch path but it makes 1 call for retreiving each entity right, other than that is there any other way. Sailu

Not built in. We use a stored procedure that uses a CTE to return all subEntities and then we manually build the tree from the returned results. This way all of the recursion is done on the db. CTEs are only available in SQL 2005 I believe. IF you are looking for another solution there is a post on here that Frans references about adjacency lists that lets you execute a simliar query based on hierarchy id.

Here's some explanation from Celko http://www.sqlsummit.com/AdjacencyList.htm.