• Thank you very much, I didn't have any idea how to do it.....

    But if I insert another record in the table

    insert into ##prova values ('$',2000)

    Is it a way to have this result?

    <root>

    <obs id=”0”>

    <dim name=”Valuta” value=”EU” />

    <dim name=”Misura” value=”1000” />

    </obs>

    <obs id=”0”>

    <dim name=”Valuta” value=”$” />

    <dim name=”Misura” value=”2000” />

    </obs>

    </root>

    with the your code I have:

    <root>

    <obs id="0">

    <dim name="Valuta" value="EU" />

    <dim name="Valuta" value="$" />

    <dim name="Misura" value="1.000000000000000e+003" />

    <dim name="Misura" value="2.000000000000000e+003" />

    </obs>

    </root>