Hi, I'm hoping someone can give me one or two pointers here. I'm looking at a fairly old application which currently uses nested loops in classic ASP to load pages. Needless to say this is fairly slow so I am looking to rewrite this as SQL stored procs. The only was I can think to replicate the functionality is by using nested cursors which clearly is not ideal either, although we are not looking at vast volumes of data. Anyway, I was hoping somebody may have a more suitable and efficient solution. We are dealing with 3 levels of hierarchical data. Thanks!