Hi Sergey,

No problem. It's an interesting exercise but I've a feeling I'd be loading too much logic onto the SQL server anyway...

Thx,
Viv

>Hi Viv,
>
>I didn't forget about it but I don't have time to look into it right now, maybe on weekend.
>
>>
>>Following my last post:
>>
>>I don't think this is do-able with CTE/Recursion. Where the quantity for a sub-recipe is specified as an absolute amount the total weight of the recipe is required before the amount of each 'ingredient' can be calculated.
>>
>>And, AFAICS it's not possible to get aggregates within the recursive query?