I had this question after viewing Help with scripting the SQL and show result
After running the query script:
WHERE date_colname = GETDATE()
This @@ROWCOUNT will show a number, this number I want it to show in a xml file, this xml need to be create with a random name never mind what. I also want the file show the error if there is any error output.