Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nickfinity
Yak Posting Veteran
55 Posts |
 Posted - 2003-02-18 : 22:18:06
|
| Alright, alright, before I get flamed let me just say that I've looked at countless posts on this subject. I feel like I'm just missing something incredibly stupid, but maybe I'm not. I've got sort of the standard hierarchy setup - an ID, Name, and ParentID. It can go down any number of levels. I want to be able to do a search for a given top-level node where the name of a record any number of levels down is like something. Is this easily possible? Maybe I'm just getting tired and should have quit working hours ago, but here's another beer hoping that it's easy.Thanks,Nick |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Searching a node of a hierarchy