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 |
|
srikhanth
Starting Member
3 Posts |
 Posted - 2004-09-22 : 17:09:16
|
| tblGroupPkID Desc GroupID41 Points 0165 Circuit 41166 First 165167 East 166168 West 166169 South 166170 Test 41171 Second 165172 East 171173 West 171174 East 170175 One 174176 West 170177 two 176 final output will be tree structurePoints Circuit First East West South Second East West Test East One West Two |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-22 : 17:17:52
|
| I've been looking for a chance to use this great sitehttp://www.fuckinggoogleit.com/search?query=sql+server+tree+hierarchyWait a few secs after going to it for your answer.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
srikhanth
Starting Member
3 Posts |
Posted - 2004-09-22 : 17:54:23
|
i am using ms-accessquote:
Originally posted by nr
I've been looking for a chance to use this great sitehttp://www.fuckinggoogleit.com/search?query=sql+server+tree+hierarchyWait a few secs after going to it for your answer.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
|
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-22 : 18:37:55
|
| why would you do this in access... and isn't there a tree object?Corey |
|
|
|
srikhanth
Starting Member
3 Posts |
Posted - 2004-09-22 : 18:55:05
|
i am doing project using vb with ms-accessfinal output should bePoints ----- Circuit--------------First--------------------East --------------------West--------------------South--------------Second --------------------East --------------------West ------Test --------------East--------------------One--------------West--------------------Twoquote:
Originally posted by Seventhnight
why would you do this in access... and isn't there a tree object?Corey
|
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-22 : 19:20:20
|
| See http://www.nigelrivett.net/RetrieveTreeHierarchy.htmlIt does what you want in t-sql, just convert it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
tree structure