SQL Server - returning xml child nodes for xml column
Use .query
to extract xml.
eg
select XmlData.query('/application/educationHistory/*'),XmlData.query('/application/experienceHistory/examiningExperienceHistory/*'),XmlData.query('/application/experienceHistory/teachingExperienceHistory/*')
Try this:
SELECT ID, Created [DATE] XmlData.value('(application/details/@firstname)[1]','varchar(max)') [FirstName],XmlData.value('(application/details/@lastname)[1]','varchar(max)') [LastName],XmlData.query('/application/educationHistory'),XmlData.query('/application/experienceHistory/examiningExperienceHistory'),XmlData.query('/application/experienceHistory/teachingExperienceHistory')FROM T