Step-By-Step Instructions on How to export query result to .csv file in SQL Server 2008
1. Open SQL Server Management Studio
2. Go to Tools > Options > Query Results > Results To Text
3. On the far right, there is a drop down box called Output Format
4. Choose Comma Delimited and click OK