Setting up hierarchical data in Microsoft SQL Server
Background I have more than once been called upon to set up an SQL database where data is organized in a hierarchy. Examples might include employees set up in an org chart, or a set of ideas arranged in a…
