Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Query output not display in HTML format RE: Query output not display in HTML format

  • August 27, 2016 at 1:01 pm

    #1897960

    Thanks Ed Wagner.. As per your suggestion results are coming email body two different table format after changed as below coding.

    But second table heading joined with last row of first table, it is not display separate heading after completion of first table.

    Please find the attached HTML report format.

    1. First table

    Before:

    SET @body ='<html><body><H3>RAIL Users</H3>

    changed :

    SET @body ='<html><body><H3>RAIL Users</H3></table>

    2. Second Table

    Before:

    SET @body ='<html><body><H3>ROAD Users</H3>

    changed :

    SET @body ='<html><body><H3>RAIL Users</H3></table>

    Thanks