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)