SELECT 1 AS TAG
, NULL AS PARENT
, CST_ID AS [ROW!1!CST_ID]
, NULL AS [CST_ID!2!]
, NULL AS [CST_NM!3!]
, NULL AS [CST_TYP!4!]
FROM MY_TBL
UNION ALL
SELECT 2 AS TAG
, 1 AS PARENT
, CST_ID
, CST_ID
, CST_NM
, CST_TYP
FROM MY_TBL
UNION ALL
SELECT 3 AS TAG
, 1 AS PARENT
, CST_ID
, CST_ID
, CST_NM
, CST_TYP
FROM MY_TBL
UNION ALL
SELECT 4 AS TAG
, 1 AS PARENT
, CST_ID
, CST_ID
, CST_NM
, CST_TYP
FROM MY_TBL
ORDER BY [ROW!1!CST_ID], [CST_ID!2!], [CST_NM!3!], [CST_TYP!4!]
FOR XML EXPLICIT
FOR XML EXPLICIT 사용예시
|
2012.07.18 17:01:43
|
2012.07.18 17:01:43
|
617
|
Aiden
Total of Attached file
0.00 Bytes of 0 files
2012.10.29
2012.10.19
2012.09.04
2012.09.01
2012.07.19
2012.07.18
2012.07.10
2012.07.05
2012.07.03
2012.07.02
2012.06.29