ilugopal (2/22/2013)
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 user1
xys.com sql24 user1
xys.com sql24 user1
I dont want this "---------" symbol. I want the o/p as
Server_Name Instance_name User_name
xys.com sql24 user1
xys.com sql24 user1
xys.com sql24 user1
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.
--Jeff Moden
Change is inevitable... Change for the better is not.