InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 23:04:30 GMT20http://www.sqlservercentral.com/Forums/Topic1422965-391-1.aspx[quote][b]ilugopal (2/22/2013)[/b][hr]While I'm exporting sql query details to CSV file I get the column headers and after the column I get minus symbol below the column headers followed by the data. IS there a way where I can get only the column headers and not the minus symbol.Server_Name Instance_name User_name ------------- -------------- ----------xys.com sql24 user1xys.com sql24 user1xys.com sql24 user1I dont want this "---------" symbol. I want the o/p asServer_Name Instance_name User_name xys.com sql24 user1xys.com sql24 user1xys.com sql24 user1[/quote]How are you doing the export? For example, are you using SQLCmd, BCP, or someother method? I ask because it does make a real difference.Fri, 22 Feb 2013 16:01:14 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1422965-391-1.aspxyou could use BCP as well.[code="plain"]BCP "select col1+','+col2+','+col3 from dbo.table" queryout c:\temp\file.csv -c -T[/code]or if you have xp_cmdshell enabled you can run it from SSMS or sql agent(note: xp_cmdshell can be a security risk).[code="sql"]exec xp_cmdshell ''bcp "select col1+','+col2+','+col3 from dbo.table" queryout c:\temp\file.csv -c -T''[/code]Fri, 22 Feb 2013 07:54:11 GMTRobert klimeshttp://www.sqlservercentral.com/Forums/Topic1422965-391-1.aspxTwo options in my opinion:-1 Run the query to grid then on the grid Right click on grid -> Select all -> Right click on grid ->copy with headers -> paste into excel save as CSV.2 If you want to run this on a scheduled basis use SSIS to export the data as csv using a query along the lines of select Server_Name, Instance_name, User_name union all select col1, col2, col3 from table"Fri, 22 Feb 2013 04:16:08 GMTStuart Davieshttp://www.sqlservercentral.com/Forums/Topic1422965-391-1.aspxWhile I'm exporting sql query details to CSV file I get the column headers and after the column I get minus symbol below the column headers followed by the data. IS there a way where I can get only the column headers and not the minus symbol.Server_Name Instance_name User_name ------------- -------------- ----------xys.com sql24 user1xys.com sql24 user1xys.com sql24 user1I dont want this "---------" symbol. I want the o/p asServer_Name Instance_name User_name xys.com sql24 user1xys.com sql24 user1xys.com sql24 user1Fri, 22 Feb 2013 03:51:01 GMTilugopal