hi, i created stored stored procedure to send mail . so, i desinged HTML format inside the stored procedure.
so, How to assign right alignment in below(price, qty) HTML "SQL Query".?
N'<TABLE BODY BGCOLOR = #ffffff ALIGN = CENTER HEIGHT = 2% WIDTH = 95% CELLPADDING = 2 CELLSPACING = 2 BGCOLOR=#2d58a6 BORDER = 0 > ' +
N'<TR ALIGN = CENTER BGCOLOR = #2d58a6 HEIGHT = 10% >' +
N'<TD style="font-family:Arial, Helvetica, sans-serif; color:#ffffff; font-size:14px; text-align:right; line-height:25px;">PRICE</TD>' +
N'<TD style="font-family:Arial, Helvetica, sans-serif; color:#ffffff; font-size:14px; text-align:right; line-height:25px;">QTY</TD>' +
N'</TR>'+
CAST ( ( SELECT
TD=convert(char(10), round(tbname.PRICE,2)),'',
TD=SODETAIL.QTY, '',
TD=convert(char(10),round(Tbname.PRICE * tbname.QTY,2)),''
Go to the complete details ...