RBarry,

I believe I solved the problem but I don’t know why it works. It appears that the order of calculations has an effect. In the anchor part of...

That is my only error. I will try to simplify the query so that it is easier for you to see what I'm trying to achieve.

I am uploading a...

Hi RBarry,

Thanks for your reply. I tried what you are suggesting and the quantities at the end of the tree were too low. The tree can be 20+...

Below is the error message I get when I try to do the multiplication:

Types don't match between the anchor and the recursive part in column "Qty" of recursive query "BOMCTE".

Thanks Jim.

GSquared,

Thanks! I'll give that a try in one of the databases I'm working with and let you know.

Mike

GSquared (4/18/2008)

---

MikeAngelastro (3/13/2008)

---

I was able to solve the many-to-many situation typically found in a product tree by using a recursive cursor in a stored procedure continuously adding to a temp...

I was able to solve the many-to-many situation typically found in a product tree by using a recursive cursor in a stored procedure continuously adding to a temp table until...

Nice explanation.

Assuming that a query is correctly structured, what in the data will cause extra rows in the query result. Does the recursion assume that each child...