Home Forums SQL Server 2005 T-SQL (SS2K5) SQL DB Email sending,HTML body formatting from two tables RE: SQL DB Email sending,HTML body formatting from two tables

  • 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!!