Hi -
I am exporting some data to a text file but my text file has to have Line feed (LF) in stead of CRLF as the row terminator. I have been trying all sorts of things to work but I keep getting the carriage return instead. Does anyone know how to do this??
DECLARE @cmd varchar(1000)
SET @cmd = 'bcp "EXEC " queryout "\hcrmelig2.txt" -c -UTF8 -r' + char(10) + ' -T -
EXEC master..xp_cmdshell @cmd