|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hierarchial tree with child count, indentation and dynamic levels
Hi,
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 : |....Misc |.....Upgrade Landscaping |.....Flood Lights Front |.....Flood Lights Rear |.....Humidfier |.....Air Cleaner |.....test1 |.....Rough In Basement Full Bath |....test |....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. |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Hierarchial tree with child count, indentation and dynamic levels |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|