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 table...

Rabia Mansour (3/18/2007)

---

Thanks for the article.

My questions is : Suppose we need to relate one row data to two parents. By doing that I get only one instance of that...

Satish Jha (5/24/2006)

---

Thanks for this article. I have one question here -how can I sort the result from CTE in hierarchical order as well as siblings on some orther order...

The CTE method of...

PW (3/9/2005)

---

The sample VB.net code for comparison contains both syntax and logic errors.

In VB.Net, an IF is ended by "End If", not End.

Also, "

Refactored code:

Private Function Factorial(ByVal number...

Sorry, there's a typo in the join. Should be "qtys.qtyorderid" (with an "s" at the end).

You'll also need to make sure it uses your actual table names and the...

Can you include the code that does the updates? That would certainly make it easier to figure out what's going on.

Yep. That'll do it. (I like the ones that use Numbers tables better, but that one will certainly work.)

Then, select the first six from that function, and you...

Cool biz. Glad I could help.

The purpose of these columns is for assigning IDs to all of the data in the multiple tables. I figured that assigning identities would've been the easiest approach to...

I'd go with a derived table from the items table to get the quantity of items, then an "in sub-query" to get the orders.

For example:

select orderid, name, date, isnull(qty, 0)...

Looks good to me!

Then you just need to add that stuff about "Target" to the Where clause.

Something like "Where t1.Name = 'Target' and t2.Name != 'Target'".

The query is built for using one table....

GSquared - Thank you. I didn't know about the row_number() function and now I know a little more about it. However, I still cannot seem to seed the...

Matt: When I saw your post right after I posted mine, my first thought was "tag, you're it!" 🙂