Yea, i know what SQL tells me but I post it here cause i thought someone will help me rewrite it.

I forgot to post it here but iv already change it to UNION ALL and it work correctly :).

At this moment im facing another problem, here is example :

WITH XMLNAMESPACES(DEFAULT...

I will check it at the evening when i will have Access to the PC

Could you just show me an exmaple?

Like i had this :

SELECT (SELECT 'test' AS whoSend,...

Isnt there any way to add it in my SQL procedure or c# script?

I will send created xml to another person who gave me a example how this xml should look like and this prefix was in it so i think i need...

Thanks for fast answer, the XML is generated by SQL and then script in c# save it and add some things.

As you can see Iv already try this, its generated...