Home Forums SQL Server 2008 T-SQL (SS2K8) Need recursive CTE to extract BOM Model/Option columns with structure for lower level items RE: Need recursive CTE to extract BOM Model/Option columns with structure for lower level items

  • You, sir, are officially "The Man"!

    Thank you very much. Your solution works and I have learned something about CTE's to boot.

    You also gave some ideas about to make use of the [SORT] concept using ROW_NUMBER() to maintain sort order when ambiguities arise in the concatenated string.