Hi:
I have no problem generating a SQL2008 query with results in XML. What I don't know how to do is how to get it to create a file on disk so that I can import into an unrelated application in it's UI.
Any help is appreciated.
Thanks
Any thing less, you can try lower-end solutions basically use [1] sp_cmdshell with bcp, or [2] bcp in command line prompt, or [3] write some wps script... In any case, it may not be as straightforward as one may anticipate as some configurations are not default to allowing it. you have to pass the question to mssql forums, starting from the above as it is not even remotely related to this forum.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.