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

Hi,

You already have two solutions from me and one from SaravanaC in previous posts that will work quite fine for 1000 rows.

Is there anything wrong with those solutions?

---

HTH, Regards, Dean Savović, www.comminus.hr/en/