Question: how to export data from sql server to csv file using sqlcmd?
Answer: SQLCMD –S <<ServerName>> –E –Q "EXEC AdventureWorks2008R2.dbo.uspExport" ... 
SELECT TOP 5 BusinessEntityID,
1,Chief Executive Officer ,M, 1963-03-02. ... 
bcp "EXEC AdventureWorks2008R2.dbo.uspExport" queryout "C:\DataBCP.csv" –c –t , –S (local) –T.