Another Way Of Doing This Is To Create A Generic Function That Puts The Values In A Table and Sum The Resulting Table.
i.e. SELECT SUM(*) FROM dbo.ParseByComm a('1,2,3,4,5,6, 7,8')
/*************** *************** *************** *************** *****
**** Parse A Comma Delimited String Into A Table
*************** *************** *************** *************** *****/
CREATE FUNCTION dbo.ParseByComm a (...
dvroman
Last Activity: Feb 9 '12, 08:53 PM
Joined: Dec 23 '05
Location: California
-
I found the answer:
EXEC @hr = sp_OAMethod @imsg, 'CreateMHTMLBod y', NULL, @body, 0, '',''
works!!!!Leave a comment:
-
CDOSYS Mail Using SQL Server
The procedure works without problems for the basic 'textbody' and 'htmlbody' type messages. The problem is I would like to get the CreateMHTMLBody method working. This works beautifully as a VBScript which I'm attempting to convert to SQL.
CREATE PROCEDURE usp_send_cdosys mail
@From_Addr VARCHAR(500) ,
@To_Addr VARCHAR(500) ,
@Subject VARCHAR(500),
@Body VARCHAR(4000) ,
@SMTPserver VARCHAR(25) = 'localhost',...
No activity results to display
Leave a comment: