Hi Sean,

Look at using Common Table Expressions (CTE)

Here is a rough sample based on your details


Thank you for the pointer to CTE and the example.

I have only looked at CTE briefly once before (for representing tree structures), so it will take me some time to do some reading and to dissect your example.

BR Mike

Reply via email to