I',m new to XML and here is what I need to do...
I want to create a SQL query to pull data and update a field on a table with current date and another field an "X"
I need the data in the select to be written to an XML.
I then need the XML file emailed,
Once emailed I need to run another query to update the 'X" to 'Y' showing its been sent...
I assume I can do this from some job steps?
I really don't know where to start??