Use CHARINDEX() to find the position of the open/close parens, and then use SUBSTRING() to get the parts between them, and REPLACE() to swap that with an empty string?

Sounds like...

Aaron,

is there an easy way to identify those?

Pieter

Live and learn, I guess.

I might have to revisit this and rewrite it when I learn how to do it better. I think part of the challenge is that it's...

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, 2 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, 2 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, 2 months ago by pietlinden. Reason: Clarification

Do you have some sample data?

CREATE TABLE scripts, INSERT scripts, please.