Every month I have to update my database, do some queries, and export the result to a massive delimited text file. As of now, everything is able to fit into one text file, but the size jumps significantly each month. Last month it was about 2 gigs, this month it's 3 gigs, and I suspect we'll reach some size limits next month. (If I'm not mistaken, text files have a 4 gig limit.) What would be the most efficient way to solve this problem? Is there a way to "split" a single query so that it exports into multiple files with headers, or would I have to create multiple queries?