Hi Viv,

If you post comprehensive test data (CREATE TABLE, INSERTs), I can take a look at it.

>
>>It can be done in SQL 2005 with recursive CTE (Common Table Expressions).
>
>I figured that if it was possible CTE would be needed. Just can't quite get my head around the fact that some rows in the Components table are 'recursive' whilst others reference the Parts table. I'll give it a try (and probably fail :-{....)
>
>Maybe the design is wrong and I need 'dummy' entries for parts in the Components table?