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?