Hi I want to design a Stored Proc to send out emails in the followinf format. Insert Data(1 Paragraph- About 10 sentences- Remains the same for all emails) Insert Table (Different for different emails) Static Data (1 Paragraph - About 15 sentences- Remains the same for all emails) I know how to get the table there but what would be the best way to Insert the 2 paragraphs? Store them in a table? Or in a temporary folder? Thanks, Shivu
Either store them in a table or leave them as data within the stored procedure. Both solutions would work easily, it depends on how often changes would be made to the static paragraphs and who would make potential changes to them. It would be better to allow users permissions to update that data in a table than alter the procedure.