I would need the query in figure 20 and the result in figure 21 which do not show up in the article.
I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, I must display the top level part of the recursion in every line of the result. (In the example there should be a field "Product" filled with "iSeries Power5 server" in every line of the result.). I must be able to distinguish the parts of different products.
Would you be so kind and post the corresponding T-SQL query?