Hi Cetin,

>In SQL2005 AdventureWorks database check stored procedures. If I don't remember wrong one the procedures was almost exactly this, creating a bike using CTE with recursion.
>
>PS: Looks like I remember right:)
>uspGetBillOfMaterials
>uspGetWhereUsedProductID

Thx. I'll take a look at that. I actually found several examples on the web (the most useful one, as usual, *after* I struggled to a solution).

I've still got one problem though- see my post to Sergey...
Regards,
Viv