Is it possible to create a recursive query in SQLServer?
I have a table that contains a parent/child record relationship and I want
to build a tree without client side processing.
ID Parent
1 Null
2 1
3 Null
4 2
5 1
6 Null
7 2
8 6
Needs to be sorted as
-1
- 2
- 4
- 7
- 5
-3
-6
- 8
TIA,
Duane
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2618
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
