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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-04 : 20:10:46
|
Alan writes "SQl table consists of
source VARCHAR(200)
destination VARCHAR(200)
Each source, destination record is unique. There are thousands of records.
My query is, using a given source and destination, query the database to discover if there is a path between them.(Links to the next site.)For example, if www.yahoo.com and www.dcu.ie were the source and destination entered, then an output of (data made up for example)
Source destination
www.yahoo.com www.msn.com
www.msn.com www.iol.ie
www.iol.ie www.ucd.ie
www.ucd.ie www.dcu.ie
is found. A path has been found between them. Please help, im rightly stuck" |
|
|
|
|
|
Source and destination queries, links on web pages