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,

'123' AS Id,

'321' AS test,

'PL' AS where,

'PL' AS from,

'Warsaw' AS postOffice,

(SELECT @datum ) as "date",

(SELECT 1 AS constValue,

(Select (@value)) as weight,

(SELECT count(*)

) AS all,

'' as number,

'PL' as sendFrom,

'type' as itemType

FROM database

FOR XML PATH ('testtest'), TYPE)

FOR XML PATH (''), ROOT ('something'));

And can you show me how should i do it?