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 - 2007-01-08 : 08:06:39
|
| Dayananda Ratho writes "connect by prior.how to use 'connect by prior' while searching for members related in a Multi Level Marketing Member search. The tree is like a matrix. One member can only put 3 members under him. Then the three can put 3 each under them and the level grows. If after 6 levels we want to know the Left,Middle and Right leg member details. We tried 'connect by prior' but its giving syntax error. select memberid, membername, sponcerid from member start with memberid='A0000001' connect by prior memberid=sponceriderror : incorrect syntax near memberSQL SERVER : SQL SERVER 7.0WINDOWS NT 4.0 SP4." |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-01-08 : 09:34:45
|
| Is that supposed to be SQL?CODO ERGO SUM |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-08 : 09:38:13
|
| This is just what we need, another MLM company...Write a stored procedure to do this you ask for.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
SQL SERVER KEYWORD 'connect by prior.'