Thanks Mark that is exactly what I'm looking for!

Simple and fast!

😀

Not really let me put a full copy of the example:

--Okay Slightly different sample data

DROP TABLE Contracts

CREATE TABLE Contracts (ID INT IDENTITY, Contract_Description VARCHAR(50), StartDate DATETIME)

DROP TABLE Sections

CREATE TABLE Sections...

For my question on the forum I drastically simplified the actual data structures to hopefully get a concise answer.

Basically, I have a screen that needs to list all the...

Thanks very much for your quick and comprehensive response!

I've been reading all about recursive queries, loops and hierarchical data structures getting more and more frustrated. All I want...