Re-Inventing the Recursive CTE

added by DotNetKicks
2/10/2017 6:49:15 PM

1 Kicks, 304 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