Send an email for each line in the result set

Question

I would like to send an email for each row of the result set using sp_send_dbmail.

What is a suitable way to accomplish this without using loops?

Edit: I do not insist that the loop is not suitable here, but is there a set-based way. I tried to create a function, but the function cannot call the stored procedure inside it. Just another func or extended sp (which I wouldn't do either).

Answer 1

The best way to achieve this is to put the email sending logic in a user-defined function.

SELECT MyEmailFunc (emailaddress) FROM MyTable

, , , . :

UDPATE MyTable SET SENT = MyEmailFunc ( ) = 0

Answer 2

- , ( ).

, , .

, .

.

( , ) , .

"" , , , , - -, .

(, ), , .

.

- , , , "" . .

Answer 3

, :

"SendMails" Insert

sp_send_dbmail

:

Truncate Table SendMails

insert into SendMails (From, To, Subject,text) Select field1,field2,field3,field4 from MyTable

Answer 4

, . .

WHILE SQL, " "

BTW: ,

Answer 5

, , SQL Server: -D

SSRS - TSQL .