My code is below,  my issue is when this executes,  lets say the query brings back 2 email address,  instead of sending one to each name it send 2 to each name.  How/where can I fix this??

CREATE   PROCEDURE usp_email_ccb

AS

DECLARE @TITLE VARCHAR(500)

DECLARE @DESCRIPTION VARCHAR(500)

DECLARE @REQUIREMENTS VARCHAR(500)

Declare @MyRecipients nvarchar (255)

Declare @NEWMessage nvarchar (255)

Declare @NEWSubject nvarchar (255)

DECLARE @RECORD_NUM NCHAR(2)

Declare MyCursor Cursor For

Select LOGINID From USERS  Where TASK='CCB'

Open MyCursor

Fetch Next From MyCursor Into @MyRecipients

While @@Fetch_Status = 0

BEGIN

Print @MyRecipients

Fetch Next From MyCursor Into @MyRecipients

select  @record_num=[id],

 @title=[title],

 @description=[description],

 @REQUIREMENTS=[REQUIREMENTS]

 from display a,(select max(id) mxid from display) b where a.id=b.mxid

SET @NEWSUBJECT='YOU HAVE AN IT REQUEST TO APPROVE!!!  THIS IS A TEST EMAIL FOR THE WAP TOOL, JUST DISREGARD!!!'

SET @NEWMESSAGE='TITLE:  '+@TITLE + " " + +CHAR(13)+ +CHAR(13)+ 'DESCRIPTION:  '+@DESCRIPTION +  " " + +CHAR(13)++CHAR(13)+ 'REQUIREMENTS:  '+@REQUIREMENTS +  " "++CHAR(13)++CHAR(13)+ + 'Click on this link to view your request.  http://localhost/WAP/db/ba2btpeb2.asp?a=GETRECORD&ID='+@RECORD_NUM

Exec Master.dbo.xp_sendmail

 @MyRecipients,

 @SUBJECT =@NEWSUBJECT,

 @MESSAGE=@NEWMESSAGE

End

Close MyCursor

Deallocate MyCursor

GO