The result is C:\MyTestFile.txt and has the information I need to have. The problem is, the fields in the text file are not separated by a tab delimiter. It appears to be a report showing the fields requested.
How can I have the text file created as a delimited text file?
The -o parameter in SqlCmd just output the log of the command executes against the server. It does not gives you option to delimit the output. In order to use the output your sql query in delimited text file use
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.