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…
How to fill a formula into a large number of cells in Excel
I’ve been working on a project in Microsoft Access with a table with over 875000 rows – probably larger than the average Access database, but well within the limits of what Access can handle [1]. The table is indexed, and…
