I want to count left and right child in tree in sql server 205

My Table Syntax is below..

Id(Int)    [MemberID(varchar(20)]    [ParentID(varchar(20)]   [Position(char(1))]   [Name(varchar(50)]

1             A001                                        NULL                             L                                 ARIF
2             A002                                        A001                             L                                 SAM
3             A003                                        A001                             R                                 RAM
4             A004                                        A002                             L                                  ABC
5             A005                                        A002                             R                                  XYZ

my problem is how to count total left and right member of particula MemberId ---------- Table structure and column definition is above.. Thanks in Advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

preetam gawade15y ago
hey can u tell me how can i display all this in a report or my web page in asp.net...???? plz urgently required
Ravi K Kashyap15y ago
SELECT
PARENTID, POSITION, COUNT(*) FROM #TBL_MEMBERS
WHERE
PARENTID IS NOT NULL
GROUP
BY PARENTID, POSITION
ORDER
BY PARENTID
Jiteendra Sampathirao15y ago
select count(*) as total from tablename where memberid=parentid;