can somebody help me. i have this simple record.
error_reference_uid item_number error_code
1234567 13579 odd
1234567 2468 even
and i want to create this xml.
i tried this
SELECT item_number, error_code, Qty FROM xml_file_item_errors FOR XML AUTO, TYPE
and gave me this result.
please help.