Joined query

[sgebbie]

I have a table with 3 fields, SponsorId, Id, Name

I am trying to write a query that'l produce hierarchical data, the problem is the id fields are not sequential nor obvious (1.1.2... more like 15358874 is a child of 55888824)

I am havin real problems because of this, I have 252 records and so far have only been able to export 13 (all from the first element after root), once that subset has finished it doesnt go back to the start and get the next node.

i tried using joins but i just go into infinite loop.
Can anyone give me any help, or sample code, once I can get all elements exported then i can continue with my work

any help would be appreciated
thanks

 

[swampBoogie]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_5yk3.asp