SQLCMD Assistance Needed -- 2
Budget: $10 – $50 USD
I have a stored procedure on a MS SQL Server that is running a SQLCMD statement to output a CSV file in the following format where #sqlStatementHere# is the SQL string. I won't give specifics to the database structure as that part is irrelevant.
sqlcmd -s, -W -Q "set nocount on; #sqlStatementHere#'" | findstr /v /c:"-" /b > '+@OutputFilePath;
My problem is that some varchar fields contain special characters such as quotes and double quotes and commas. This is causing some rows of the CSV file to be invalid.
I am assuming we can pass in some parameter to this SQLCMD to escape special characters or perhaps wrap the entire varchar data in double quotes.
You will not be given access to the database for this project.
You can easily create your own table locally with some test data.
You can give that script update to me. I will update it and then test the code.
I must be 100% satisfied with the results and the bug must be fixed accordingly for the escrowed milestone to be released.
Note that this is a bulk export of data and I do not really see an alternative to SQLCMD that would be higher performance. I am limited to an older version of MS SQL Server.
I need this completed with a couple of hours max. Please bid 1 day or less.
Post the term #sqlGuru in your bid to me so I know you have read all this and understand.
sqlcmd -s, -W -Q "set nocount on; #sqlStatementHere#'" | findstr /v /c:"-" /b > '+@OutputFilePath;
My problem is that some varchar fields contain special characters such as quotes and double quotes and commas. This is causing some rows of the CSV file to be invalid.
I am assuming we can pass in some parameter to this SQLCMD to escape special characters or perhaps wrap the entire varchar data in double quotes.
You will not be given access to the database for this project.
You can easily create your own table locally with some test data.
You can give that script update to me. I will update it and then test the code.
I must be 100% satisfied with the results and the bug must be fixed accordingly for the escrowed milestone to be released.
Note that this is a bulk export of data and I do not really see an alternative to SQLCMD that would be higher performance. I am limited to an older version of MS SQL Server.
I need this completed with a couple of hours max. Please bid 1 day or less.
Post the term #sqlGuru in your bid to me so I know you have read all this and understand.