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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!