>Hi - I need to see some data from a customer's MSDE database. The query is simple and ideally I want to send them a stored procedure that they can execute with OSQL and then they send me the output back. The resulting file could be a CSV or XML file.
>
>Is there a way to produce a CSV or XML file from a stored procedure that they can email me back?
>
Hi Chris,
Would this work for you?
osql -S myserver -d pubs -E -s"," -w 1000 -o h:\tmp\osql.txt -Q "SELECT * FROM authors"
osql -S myserver -d pubs -E -s"," -w 1000 -o h:\tmp\osql.txt -Q "EXEC reptq1"
--sb--