I need to create an HTML file in t-sql that will be emailed. I am having trouble running the commands to generate the HTML that needs to be written to an output file. What would be my best option? I've tried some scripts with the xp_cmdshell command, but it can't write html tags to the file. How can I build the HTML file with all proper tags, and have it saved so I can email it when finsihed?
Thanks for your help!
Thanks for your help!