Dana Medley (7/22/2013)

---

Maybe this will help.

SELECT 1234 AS '@TranID', 'ABC123' AS '@OrderNum',

'MY' AS 'Current_Location',

(

SELECT 'OK' AS '@Code', 'FINE' AS '@Reason_Code', 'KUU1234' AS 'Remark'

FOR XML PATH('Status'), TYPE

) AS 'node()',

'A5555' AS 'Consignment_Number',

(

SELECT '0' AS '@Consignment_Number', '0' AS '@Box_Qty'

FOR XML PATH('Total_Shipped'), TYPE

) AS 'node()'

FOR XML PATH('Track_N_Trace')