4 ms·
Might want to check Joe Celko's Trees and Hierarchies in SQL to see if there's a normalized way to do what you want.
by brlewis 19y ago
Might want to check Joe Celko's Trees and Hierarchies in SQL to see if there's a normalized way to do what you want.
- Flemlord 19y agoThanks. I just overnighted it from Amazon. My coding partner wants to use recursive database queries to do this--I want to avoid it because it's slower, breaks our object model, and makes the application non-database-agnostic. (Currently, we're using NHibernate and can run on most major databases.)