Yes, I'm sorry. Just got it and didn't had time to reply.

Thanks for the fast reply.

I'll try to update my first comment or remove it

Hi,

The last example in the article is not working, gives an error:

XQuery: SQL type 'xml' is not supported in XQuery.

THe example is:

DECLARE @x XML

SELECT @x = '

<Employees>

<Employee...

What is the definition of Individu? does it allow nulls in the mentioned column?

Thanks, I've found something very eleganst.

Thought to share it:

create table #t (x xml)

set @x = '<root>

<lang>....</lang>

<testRoot>

<test>

<id>1</id>

...

yes

if parameter @id = 2 then the result should be

<root>

<lang>....</lang>

<testRoot>

<test>

<id>1</id>

<name>A</name>

</test>

<test>

<id>2</id>

<name>C</name>

</test>

</testRoot>

</root>