RE: sp_send_dbmail; one record at a time

SSC Guru

Points: 323504

December 5, 2013 at 8:50 am

wheelsthatgrip (12/5/2013)
Hello All,
I am using dbmail to send out the results of a query. The results are being sent to SMS users so the output has to be limited to 160 characters.
My question is ......
How can I send out only one record per email (The records are less than the 160 character limit)?
Thank you for your input 🙂
Keith

sounds like a cursor or a loop is going to be required.

if your query results has 100 rows, is that 100 users, one per message, or 100 messages for a single user?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!