how to count hierarchical data from database?

  • Thread starter Thread starter vchaturvedi23
  • Start date Start date
V

vchaturvedi23

hellow frnds,

i hv a form of vb.net with SQL2000 connection,
how can i count the hierarchical data from database.

eg. every customer hv a id and each customer hv two downline id left
downline and right downline(either one of them will hv value or both
hv value)

Customer1
/ \
L_id R_id
/ \ / \
L_id R_id Null R_id
/ \ / \ / \
L_id nul Lid Rid L_id R_id

how can i count that Customer1 have how many id in Left and how many
id in Righ by form?
 
I recommend you post this exactly as it reads in the
microsoft.public.sqlserver.programming forum.
 
Back
Top