SQL Server 2005 Stored Procedure write data to text file

This is a small project to create a SP to fetch data from a database, combine certain fields and write them to a specific format in a text file. I will provide the basic database query to fetch the data. The SP will then have to combine certain fields and write one record per line to the text file. Data for text file will be extracted from recordset. It will be helpful to understand regular expressions and how to programatically count spaces and characters in recordsets. SQL Server 2005