Get Children?

  • 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.

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

  • 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