Recursive queries are not commonly used, yet they are very useful to display hierarchical data stored in flat tables. Unlike the “Connect by” statement in Oracle, SQL Server doesn’t provide an easy answer to build them. Here is a way to solve this with SQL Server, found after a bit of reading. Lets use a flat […]