ms sql 2008 recursion?
Posted on 2012-03-29
I have a list of items, but some "items" are kits of other items. I am trying to get a list of all physical.final items.
Example Items a,b,c,d (kit with a,b), e, f (kit c,d),
There is another table that lists if item is a "final item" - the opposite being a kit.
Selecting all items, I would like to get the list:
a (for kit d)
b (for kit d)
c (for kit f)
a (for kit f,d)
b (for kit f,d)