Kshitij:

That would be great & very nice of you.

I look forward to your function & hope that solves my problem too.

Ajay Kini

Barry:

CTE works in sql 2005 and not in sql 2000 i guess.

I am having sql 2k as back end.

What is your advise

Well as i mentioned after a particular member gets more than 950 members below the nesting error is seen when leg count is link is activated.

Please advise what needs to...

Lynn:

Thank you for your understanding and patience.

I hope i am now on the right track to receive your valuable advise to resolve the problem.

--===== If the test table already exists,...

Barry:

What would you suggest instead?

Thanks

Thanks Noel

Yes it's recursive

Thank you Lynn

The db structure is:

UserID | UserName | UserPwd|Address|ReferID|PositionType |regdate|SponsorID|UpdateDate|FranchiseeID|MemberType|ParentId|Reentry| Unit

Sample data would look like:

10000|rrs|rrs123|abc street, mumbai|9999|Left| 11-02-2008|9999|11-03-2008|9999|Bronze|0|N|

1

Hope i have provided the right data in a proper manner...