Torna al Thread
SELECT
(
SELECT
Tab1 AS id
, (SELECT
1 AS Tag
, NULL AS Parent
, (SELECT 2 as 'contenuto' FROM @tabledocu FOR XML RAW('elemento'), ELEMENTS) AS [nodo!1!!CDATA]
FOR XML EXPLICIT) AS MANCAVA
FROM @tabledocu WHERE Tab2 = '2'
FOR XML RAW ('template'),TYPE
)
FOR XML RAW ('templates'),type