title: Export a data table in CSV format sql server 2008
body: <p>I need to create a stored procedure which queries a table and creates a CSV file for that data in a specified directory location.</p>
  
  <p>how do i do it? </p>