Re-Inventing the Recursive CTE

added by DotNetKicks
2/6/2017 2:39:15 AM

2 Kicks, 279 Views

Working with hierarchies in SQL Server never fails to be absolutely fascinating. On the face of things they're super-easy to model and seem to fit perfectly well: parent_key, child_key, self-referencing FK, and you're done. But then you go to query the