Multi-Level Marketing (MLM)/Hierarchical Database

[Michael Berry]

I was wondering if anyone out there knows how to design a
database to track multi-level marketing commissions. Most
people are familiar with a pyrimid scheme and how it can
grow exponentially (unlimited). I need to be able to know
how to tie people back to their original sponsor and who
sponsored them, etc. I also need to be able to track how
deep in the pyrimid they have gone. I am completely
baffeled. I have about a year experience with SQL
server. Please let me know if anyone knows how this would
be structured and how it would track. \

Thanks in Advance!
Michael Berry

[Narayana Vyas Kondreddi]

Michael, you can have all the rows in one table and link them to each other
using ParentID. Look at the topic "Expanding Hierarchies" in SQL Server
Books Online for some ideas. For more complex examples, you might want to
search this newsgroup archive at http://groups.google.com by using the
keywords: Joe Celko SQL tree structure
Good luck!
--
HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/

"Michael Berry" <michael...@hotmail.com> wrote in message
news:5edf01c1b962$b8999110$3bef2ecf@TKMSFTNGXA10...