LutzM: Thank you, works as expected. Appreciate your help :-)...

LutzM (5/3/2014)

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...

Thanks 🙂