I have created one stored procedure which sends html format. here, inside the html tag, i have selected column from database.
for example table name : tbspmail and column name infocom . everything works fine except alignment to this td.
if you look in database it is inserted correcly like below.
**NO VALUE FOR GOOD KNOWLEDGE IN GOVT FIELD BUT IT IS VALUE FOR IT FIELD.
**GOOD** ALL VALUES & TEST GOOD, NO PAIN NO GAIN AS WELL AS IT IS EQUAL TO THIS MEANING LIKE NO BRAIN NO GAIN ALL IS WELL MR.BILLGATES IS LOVELY PERSON (TEST TEST GOOD)
EMPLOYEE SIGNATURE: X__________________________________
when i do select query inside html
N''+
N'
'+
cast((SELECT ISNULL(infocom,'')FROM tbspmail FOR XML PATH(''),TYPE) AS NVARCHAR(MAX)) +'
'+
I am getting like below,
**NO VALUE FOR GOOD KNOWLEDGE IN GOVT FIELD BUT IT IS VALUE FOR IT FIELD.**GOOD** ALL VALUES & TEST GOOD, NO PAIN NO GAIN
AS WELL AS IT IS EQUAL TO THIS MEANING LIKE NO BRAIN NO GAIN ALL IS WELL MR.BILLGATES IS LOVELY PERSON
(TEST TEST GOOD) EMPLOYEE SIGNATURE: X__________________________________
i have table width 780.
so, how can i get output with correct alignment like below:
**NO VALUE FOR GOOD KNOWLEDGE IN GOVT FIELD BUT IT IS VALUE FOR IT FIELD.
**GOOD** ALL VALUES & TEST GOOD, NO PAIN NO GAIN AS WELL AS IT IS EQUAL TO THIS MEANING LIKE NO BRAIN
NO GAIN ALL IS WELL MR.BILLGATES IS LOVELY PERSON (TEST TEST GOOD)
EMPLOYEE SIGNATURE: X__________________________________