Challenge #81: Multi-Level Bill of Materials Problem

[jjrbondoc]

Spoiler

[BSilverblatt]

Thanks for the challenge! Here is my solution:

[leozhang2work]

Spoiler

Iterative macro to dynamically add parent level information to child level, then updates the iterated results.

[ARussell34]

I didn't take this problem along the iterative macro approach path, but I was able to create a solution by identifying where the level matched the parent id values. By using a few joins and multiplications and a final sort, the output followed the given solution!

[davidhardister]

[Watermark]

Spoiler

 

[Watermark]

Spoiler

 

[EdoardoAversaTIL]

Spoiler

[jon_amanrich]

My solution!

Spoiler

[TonyAndriani]

Reposting under my new user ID.