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

Question

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.

preetam gawade · Answer

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 Kashyap · Answer

SELECT PARENTID  POSITION  COUNT (*) FROM #TBL_MEMBERS WHERE PARENTID IS NOT NULL GROUP BY PARENTID  POSITION ORDER BY PARENTID

Jiteendra Sampathirao · Answer

select count(*) as total from tablename where memberid=parentid;