Something SQL2000 is lacking is a function or SELECT clause that will return a Hierarchical Query based on records with recursive Parent / Child references.
I need to make a SQL query that does just this. Does anyone have any ideas on how I can do this in SQL2000?
Else, the best I have managed up to now in doing that is just writing it code-side rather than db-side. Never did reckon much to custom db-side functions.