Greg the Dev

Greg the Dev

How to process hierarchical data in SQL-Server using recursive CTE

Apr 11, 20211 min read

We surely have encountered data which was structure in hierarchical mode. One example is storing employees as managers and their direct reports. The usage sample are already well explained in Microsoft docs. However the most important thing to remem...