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 |
|
mrtanvirali
Starting Member
41 Posts |
 Posted - 2010-03-04 : 12:57:19
|
hello,I am working on MLM type application, In this I've 4 Zones i.e L zone, I zone, N zone and X zone, zone will change after every 4th referral e.g. in L zone user have 3 referrals as he will refer 4th referral he'll move to I zone. My question is how can i manage / store referrals? to find out that a user has referred to Mr. ABC in ? zone (whether L zone, I zone, N zone and or X zone)curently i've user information (userid, name, email and some other info) and user_referral_Mapping (userid, parentid, depth, lineage)quote:
I am followinghttp://www.sqlteam.com/article/more-trees-hierarchies-in-sqlafter reading the following link http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=2828
|
|
|
|
|
|
manage / store Referrals Zone wise