Hi Lutz

The updated code worked a treat (first time) - thank you

Dougal

This query creates the follwoing data set. It is the following data set the the CTE query is run against.

CREATE TABLE tmp_restrict

(

[seq] [int],

[seq2] [int],

[seq3] [int],

[BLDGID] [varchar] (6) NOT...