SELECT CAST ([content_html] AS XML).query('/root/Physicians/specialty/a') AS [Specialty1] , CAST ([content_html] AS XML).query('/root/Physicians/specialty2/a') AS [Specialty2] , CAST ([content_html] AS XML).query('/root/Physicians/specialty3/a') AS [Specialty3] , CAST ([content_html] AS XML).query('/root/Physicians/specialty4/a') AS [Specialty4] , CAST ([content_html] AS XML).query('/root/Physicians/specialty5/a') AS [Specialty5] , CAST ([content_html] AS XML).query('/root/Physicians/specialty6/a') AS [Specialty6] FROM [db].[dbo].[content] WHERE [folder_id] = '188' AND (content_status = 'A') ORDER BY [content_title] … Read more