SELECT a.id,
      (SELECT b.[key] AS "@ColName",
              b.value AS "text()"
       FROM @t b
       WHERE b.id=a.id
       FOR XML PATH('Col'),ROOT('AdditionalCols'),TYPE) AS keyvalues
FROM @t a
GROUP BY a.id
ORDER BY a.id;