Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-09 : 08:35:47
|
| Prasanth writes "Hi,I need to compose a HTML mail body dynamically from a table with numbers.Let me be more specific.I've a table with two colums.I'm storing id,number daily in the 2 colums respectively .Ids vary from 1 to 10 and count can be anything.One day i have data like 1,25000 2,4000 and so on.This kind of records exists daily.Once in a month i must generate an html mail with Count for each Id on each day ,Total count for all ids daily and total count Id wise and grand total.I guess you understand what i mean.I'm writing a stored procedure reading the table contents with ROLL Up kind of queries and appending HTML tags as per requirement.My problem is sometimes with the html tags in the composed mail body the size is exceeding 8000 chars.Is there any solution to attend to my problem?" |
|
|
|
|
|
CDONTS mail with more than 8000 characters