When it comes to handling large volumes of data in SQL Server—especially importing and exporting flat files like CSVs or TXT files—the BCP (Bulk Copy Program) utility is one of the most powerful tools ...

However, I need to export data from SQL server and drop it into an XML file. The table structure would be a de-normalized view, one column per field in the XML file to be populated with values.