Query output not display in HTML format

Question

Query output not display in HTML format

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 1

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

SQL Galaxy (8/27/2016)
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

Put your <H3> tag for the second table inside the <table> tag of the second table. This will be after you close your first table with a </table> tag.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

I have changed in second table as below..

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

Thanks a lot Ed Wagner .. Perfectly working as you suggested.. Thank you.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

SQL Galaxy (8/27/2016)
I have changed in second table as below..
SET @body1 ='<html><body></table><H3>ROAD Users</H3>
Thanks a lot Ed Wagner .. Perfectly working as you suggested.. Thank you.

I'm glad you got it working. Thanks for the feedback.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions