Viv,

try to get in contact with Kevin Goff here on the forum. He has publish something on his blog http://kevin_s_goff.typepad.com/ about CTE's and recursion. Maybe he can help.

Let me know when you find the solution cause I'm very intrested and curious about it.


>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?
>
>Regards,
>Viv