Binary Tree Problem in SQLServer

Hi Members
I m new in this forum, I have have Binary Tree database in SQL Server with
table fields(Mcode,Mname,LeftMCode,RightMCode). i want to display downline and pairs of each member.
can any one help me out?
Regards
Amirbkkread this.
is for OLAP, but, maybe help you.

http://www.codeproject.com/cs/database/tree_olap.asp|||From your column names, I'm guessing your are dealing with a Nested Set model ala' Joe Celko, rather than the more common Adjencency Model.
You should be able to find some code samples here:
http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=1266295
...or by googling "Celko Nested Sets".|||Thanx for reply

But i have little prob that all nodes will be freely put on any side means any member can be put on left or right side and my db will grow very fast and estimated records will be more than 100000 with in few months

so if i use lineage and depth methods can i store path in one fields
and if use set model than i think , left node must be fill first and right node must be +1 than its left node.
and in my db any node(member) should be put on any side

so guys and suggestion will be higly appreciated.
i m going to build db with in few days , plz help me out.

Regards,

Amir|||Thanx for reply

But i have little prob that all nodes will be freely put on any side means any member can be put on left or right side and my db will grow very fast and estimated records will be more than 100000 with in few months

so if i use lineage and depth methods can i store path in one fields
and if use set model than i think , left node must be fill first and right node must be +1 than its left node.
and in my db any node(member) should be put on any side

so guys and suggestion will be higly appreciated.
i m going to build db with in few days , plz help me out.

Regards,

Amir

Beta 2 Management studio navigation

A couple of questions:
-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
-- Where do you go to set up a new DTS script if it is not done with the wizard?
Thanks.
If you have a question about SQL Server 2005 Beta 2, please ask it in
the newsgroups that have been established for it. You can find out how
to access those newsgroups where you got the beta version of SQL Server
2005.
Steve Kass
Drew University
bogus_boy wrote:

>A couple of questions:
>-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
>-- Where do you go to set up a new DTS script if it is not done with the wizard?
>Thanks.
>