Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite).

In my VB.Net application, I need to be able to get the string "Hardware:CPU=Intel:Speed=3 ghz" by querying the database table above.

There is no simple way to create recursive queries that have several levels of data (hierarchical data) in SQL Server 2000.