Now, I am new to SQL and in the phase of learning while doing. I am emailing results from a query via an HTML table generated by code much like what you have shown.
It works perfectly fine and I am a little proud of myself for getting this far. Next step is my task - the consumer wants the data in two different html tables in one email. Is that possible with this?
I've tried doing
@body = @tableHTMLSQL AND @tableHTMLORACLE,
but alas that was to no great success. Again I am new so this may be a simple fix but its not obvious to me.
Thanks in advance!!