Post reply

Get Children?

  • March 19, 2002 at 7:05 pm

    #357502

    I have lots of hierarchical lookup values that are stored in a table with the structure

    ID INT

    Parent Char 6

    Key Char 6

    Value Varchar 50

    The nesting level can be up to 8 levels. I need to create a stored procedure that would return a recordset with all children and accepts the key as a parameter.

    Any help is most appreciated.

  • March 20, 2002 at 12:55 am

    #425670

    Have a look in Books onLine with the heading 'Expanding Hierarchies'. This gives a stored proc..which, maybe of use

  • March 20, 2002 at 10:54 am

    #425726

    Thanks a lot that worked great!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply