Nov 19, 2008

XML output in sqlserver 2005

SELECT 1 AS TAG,
NULL AS PARENT,
NULL AS [ROOT!1],
NULL AS [TABLE!2],
NULL AS [FIELDS!3!ertr],
NULL AS [FIELDS!3!rtr]
UNION ALL
SELECT 2 AS TAG,
1 AS PARENT,
NULL,
'TEMP',
NULL,
NULL
UNION ALL
SELECT 3 AS TAG,
2 AS PARENT,
NULL,
NULL,
RTRIM(ERTR),
RTRIM(RTR)
from temp
FOR XML EXPLICIT

No comments: