DECLARE@Sample TABLE

(

Col1 VARCHAR(20) NOT NULL,

Col2 INT NOT NULL

);

INSERT@Sample

(

Col1,

Col2

)

VALUES('SwePeso', 1),

('Demo', 2);

SELECTCol2 AS [Element/@Age],

Col1 AS [Element]

FROM@Sample

FOR XMLPATH(''),

ROOT('Data');