Information générale
Forum:
Microsoft SQL Server
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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement