INSERT INTO NTD
    SELECT
         nat.noteid, tags = REPLACE
         ((SELECT tagname AS [DATA()]
         FROM NAT
         WHERE  noteid = nat.noteid
         ORDER BY noteid FOR xml path('')), ' ', ':')
    FROM         NAT nat
    WHERE     nat.noteid IS NOT NULL
    GROUP BY nat.noteid;