Re-Inventing the Recursive CTE

added by DotNetKicks
2/5/2017 9:19:19 PM

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