Options
saving result of SP
How can I save the result of a stored procedure call as CSV and save just some columns in a particular order?
Thanks
Vaclav
Thanks
Vaclav
Comments
There is some issue with the parameter of the SP. I am getting error "SP does not exist". When I removed the parameter 'cs', getting error "SP expects parameter which was not supplied". My code:
Util.WriteCsv(
ExecuteStoredProcedure("dbo.p_selectItemsWithPathByLang 'cs'")
.AsDynamic()
.Select(x => new { x.ID, x.ITM_PATH, x.ITM_NAME }),
@C:\Temp\tables-selection.csv);
Thanks a lot!