I found a workaround myself, which seems pretty dirty, but it does the trick :

SELECT Tag = 1,

Parent = NULL,

'record!1!id' = Id,

'record!1!code' = Code,

'record!1!!XML' = CAST(XmlContent.query('//test') AS varchar(max))

FROM @Records

FOR XML...

I found a solution with dynamic SQL (I know, YUK!), using the built-in REPLICATE string function to multiply an INSERT SQL-string...

DECLARE @strSQL VARCHAR(MAX);

SET @strSQL = '';

SELECT @strSQL = @strSQL +...