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, 5 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, 5 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, 5 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...

I think I remember your article about "Find all pilots that can fly all the planes" question. (Yep, that's the one!)

Is there a way to process the "build orders" without...

Wouldn't you declare a variable to hold the filename and then use .NET functions to parse out the chunks you want that make a date? Then compare it to some...

If you're trying to get a count of enrollments for each day, then you would need a Calendar table of some kind. Are you trying to count the number of...

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