MarkButler
Programmer
I need to do what seemed like a very simple thing. Run a SQL query, producing XML output and saving that output to a text file which will be input to an EDI package.
After looking around the best I have come up with thus far is the "sp_makewebtask" method as follows:
The problem is that it likes to throw in extra CR and also does some translation of characters to their HTML equivelents. Has someone got an answer to this simple task? Many thanx in advance for any ideas.
Mark
After looking around the best I have come up with thus far is the "sp_makewebtask" method as follows:
Code:
sp_makewebtask @outputfile = 'c:\temp\authors.xml',
@query='select * from leaders for xml raw',
@templatefile = 'c:\temp\template.tpl'
The problem is that it likes to throw in extra CR and also does some translation of characters to their HTML equivelents. Has someone got an answer to this simple task? Many thanx in advance for any ideas.
Mark