how to generate ordered sequence for n number of n number of child

Hi,

If you have 2 million rows then recursion solutions that were provided in this thread will be way two slow for you. You will have to decide and implement one of the hierarchy models with redundant hierarchy data.

1. hierarchyid data type solution


2. Hierarchy and Level fields solution


3. Nested Sets solution

---

HTH, Regards, Dean Savović