I need to return a result set that represents a hierarchial tree with indentation , levels and child count in an optimal way. Something like this :
|.....Flood Lights Front
|.....Flood Lights Rear
|.....Rough In Basement Full Bath
|....Site Plan Options
|.....Per Plan Garage Right
The glitch here is i am unable to include the child / subchild count at all levels within the same result set in an optimal way.
The number of levels are dynamic in the sense , they might be n levels today , n+1 tomorrow and so on.
Any thoughts on this is greatly appreciated.