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 |
|
skatedork
Starting Member
4 Posts |
 Posted - 2005-03-03 : 12:48:55
|
| Okay so here is my problem, I know there is a solution, but I just can't put my finger on it yet :) I have a web based form that we dump HTML code into and when we click submit the stored procedure is then called which populates a table with around 40K records (this is a newsletter). It takes the code and loops through the member database creating a record for each member with the code for teh newsletter which is then sent using a custom VB mailer that pulls records from a database table. This works fine and dandy, BUT my problem lays within the fact we cannot have the HTML code more than 8000K because of SQL limitations on using text fields in a stored procedure. Is there any way to get around that restriction? Other than not using a stored procedure... :) Any help you guys can give me would be great! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-03 : 12:55:47
|
well you can save the newsletter as text field and have 4 or 5 varchar(8000) paramteres to a sporc.you split the input string between those paramteres.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Advanced SQL Stored Procedure Question