What is the query (without for xml) that you need output in the format you like? Are the codes in your xml columns in the table you are querying?