princess-336184
Newbie
Points: 7
More actions
June 8, 2006 at 8:10 am
#113373
How do I create trees in SQL Server 200
ThomasLN
Mr or Mrs. 500
Points: 521
June 9, 2006 at 11:15 am
#642860
Here is an excellent article that tells you exactly how to do this:
http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
However, please note that this solution uses a loop. In SQL Server loops are only useful for small data sets since the query optimizer is bypassed.
Good luck...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply