The part I finally figured out that threw me at first is that you filter what the CTE returns by adding a WHERE clause outside the CTE (seems to painfully...

FWIW, here's my current code... I *think* it works, but maybe it's just AdventureWorks playing tricks on me.

CREATE PROC PartsSheetForSalesOrder
 @SalesOrderID INT
AS
WITH Parts(AssemblyID, ComponentID, PerAssemblyQty, EndDate, ComponentLevel) AS ...

Here's my code so far... How do I just return the lowest level components? I feel like I'm missing a join or something somewhere...

Here's my code so...

If I sequence the Work Orders somehow, I could use one of those dreaded cursor things... then I could do something like this:

1. get complete list of components required to...

DELETE FROM TableA
WHERE EXISTS (SELECT 1 
     FROM TableB 
     WHERE TableB.DeleteDate = TableA.RecDate);

?

I guess I should have asked what you tried.

This is a "note to self", I guess, so...

Self,

this is as far as I have gotten. it's not quite right maybe, because I have yet to figure out how to...

I think you're making this harder than it really is. What specifically are you trying to learn? What kind of SQL questions are you trying to answer that you don't...

I would do the stairways in order.  They're ordered in increasing complexity, generally.

Or are you asking how to order the stairways?

What are you trying to learn?

• This reply was modified 6 years, 11 months ago by pietlinden.

Why not take them in order? (Or am I missing something?)

Could you explain in words what you're trying to do? What's your expected output?

• This reply was modified 6 years, 11 months ago by pietlinden.

Steve.

I have a question about the rCTE example. In the rCTE, the Product Assembly is "decomposed" into parts, which is then decomposed again (in the rCTE)… but how do you...

• This reply was modified 6 years, 11 months ago by pietlinden. Reason: Clarification

Do you have some sample data?

CREATE TABLE scripts, INSERT scripts, please.

a heap is a table without an index - it's unordered. You can't reorder something that's not ordered by an index.

Okay, sorry everybody. I found out that the question was way easier than I thought. (That's what happens when you don't get scripts to recreate the tables and data and...

I'm an Aspie too, so I can kind of see where David is coming from. talking to "paper" or typing on a computer might be easier because there's so much...