going through all sql fields

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

i am running through a problem, i am running a query and it returns multiple rows as i wanted, perfect. I had to send message to concern mobile no so i wrote procedure for it that's working but problem is that i am not able to send message to different mobile no i.e. no.s returned by different rows. In short i mean that i want to send messages to all numbers that are returned by query.

SQL

Select CL.[Subject],  D.Name as Designation,  D.MobileNo, CL.LetterNo,'Please Reply To Our Letter No : ' + convert(varchar(50),CL.LetterNo) as SMSMessage
  from CPOCMS.dbo.ComposedLetter CL 
  Join CPOCMS.dbo.Designations D on  CL.Designation_ID = D.DesignationID

 where   convert(date,CL.DeadLineDate) = Convert(date,DATEADD(DAY,1,GETDATE()))

 Exec dbo.ADD_SMS_InQueue 'Requires number', 'requires message'

Posted 26-May-14 20:24pm

Hunain Hafeez

Updated 26-May-14 20:56pm

ArunRajendra

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

soumyajayaraj · Answer 1 · 2014-05-26T21:11:00

Solution 1

You could use a cursor and loop through all the rows. But why dont you do a bulk insert instead of calling the ADD_SMS_INQueue in a loop?

Posted 26-May-14 21:11pm

soumyajayaraj

Comments

Hunain Hafeez 27-May-14 3:50am

Bulk insert ? sorry ?

CHill60 27-May-14 4:38am

If it is any consolation, I haven't a clue what they mean either! You already have the data on a table so I don't see the relevance of bulk insert

CHill60 · Answer 2 · 2014-05-26T22:44:00

As suggested by soumyajayaraj you could use a CURSOR - here's a CP Tip if you haven't used one before How to use Cursor in Sql[^]

Warning - cursors can get very slow with large quantities of data.

I was going to suggest using a function instead of an SP as you could have incorporated that into your query, but AFAIK you cannot send an email from a function, and the little research I've done did not offer an alternative (I only mention it for possible future use)