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://qa.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