March 19, 2002 at 10:46 pm
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 4:15 am
This is a second post, see "Get Children?" under General forum for other responses.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 20, 2002 at 10:53 am
That is right I thought I posted it in the wrong forum. By the way I see some overlap between the forum names, can you search all of them to find a topic?
March 20, 2002 at 10:57 am
Ahh, crude. No you apparently cannot search titles of forum topics. Better post it this way then http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3109&FORUM_ID=23&CAT_ID=2&Topic_Title=Get+Children%3F&Forum_Title=General.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy