Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Stored procedure

    Hi all
    I just want a procedure or query to find out all nodes of a root.
    For example root is A.its child is B.B's child is c.C's child is D.

    if i query from a table where parent=A i want to display all child nodes
    like B,C,D etc..

    Pls help me


    B.nair

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •