I have a SQL Server stored procedure that writes the query results to a .csv file. My .csv file needs to have as it's first row two columns with data
ROW1 Column1 ThisData Column2 ThatData
ROW2 and beyond, col1 col2 col3 col4 col5 col6 col7 col8 col9 col10
How can I setup my query to select the first row different than the other rows? This unique row is a header row that another program will need to process the data in the csv.
Select Row1/Column1data, Row1/Column2data, all other rows/columns