I have a table called AmendBarsetFlight. Essentially, I just want to retrieve 2 XML data type columns called ('XMLBeforeAction' and 'XMLAfterAction'). I'm trying to extract the documents contained in the ('XMLBeforeAction' and 'XMLAfterAction') columns into 2 columns called the same in the query output within SQL. Here's an example I tried earlier, but it seems to not be working the way I want it to. The AmendBarsetFlight table has a little over 16k rows. When I ran this earlier it took a long time and didn't really show me any data (empty columns) in the output as I expected, so I had to cancel the query.
SELECT XMLBeforeAction.query('data'), XMLAfterAction.query('data'),