LutzM (5/3/2014)

---

something like tihs?

select

person.x.value('(./personId)[1]','varchar(max)') as personId,

person.x.value('(./name)[1]','varchar(max)') as name,

note.y.value('(./date)[1]','varchar(max)') as [date],

note.y.value('(./text)[1]','varchar(max)') as [text]

from @xml e

cross apply e.xmldata.nodes('organization/department/person') as person(x)

outer apply person.x.nodes('note') as note(y)