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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Continuously search

Author  Topic 

Rocko
Starting Member

26 Posts

Posted - 2007-09-21 : 11:26:44
Hi Friends,

I need to make continuously search. So, based on Number I will retrieve a set that will contain other related numbers. Then I will need to display another set based of the result from the last one. And then again and again till I reach 10 child searches.
What will be the best approach to achieve that type of results?
Thanks in advance.

Rocco

Kristen
Test

22859 Posts

Posted - 2007-09-21 : 11:30:03
Sounds like you are doing a Hierarchy.

If so see: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Hierarchy

Kristen
Go to Top of Page
   

- Advertisement -