jbalbo (4/30/2013)
...I need the data in the select to be written to an XML. ...
select ... FOR XML http://msdn.microsoft.com/en-us/library/ms178107%28v=sql.105%29.aspx
jbalbo (4/30/2013)
...I then need the XML file emailed, ...
exec sp_send_dbmail http://msdn.microsoft.com/en-us/library/ms190307.aspx%5B/url%5D
jbalbo (4/30/2013)
...Once emailed I need to run another query to update the 'X" to 'Y' showing its been sent....
Post example data and XML file.