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>