@invoice int,

@xml xml

insert into tblerror([msgtext]) values('hier wel')

set @xml = (select xml from faxml where id = 12);

with XMLNAMESPACES (DEFAULT 'http://www.openapplications.org/oagis',

'http://ns.hr-xml.org/2007-04-15' as nl)

select @invoice = x.c.value('DocumentIdsΏ]/DocumentIdΏ]/IdΏ]','int')

from @xml.nodes('/Invoice/Header')x(c)

INSERT INTO tblerror ([msgtext])

VALUES (str(@invoice))

insert into tblerror([msgtext]) values('hier wel 2')