Find and divide the downline into different generation in sql server 2008

Sorry rule is not fully clear. Till what point you need to do comparison? Why it stopped at 7? Why not compare with 8? That should also be returned with first set rite?

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page