I have been struggling with this code all day today. I could have sworn everything was working fine when I left here on Friday. Per the below code(forgive me it is rather long). The top half of the code selects records from a few tables where completion date is 0. Then those records are inserted into a table called Notification. Eventually, an email program will retrieve these records from Notification table and sends an email to those concerned. The emails come in batches of 3 - emp, his/her supervisor and the supervisor's supervisor. So far, the records that are inserted into notification table always enters 0 into the 3rd email address instead of the real email address. I cannot for the life of me figure out what is happening. Can someone, please, please help. Here is the code and thanks in advance. CREATE PROCEDURE dbo.NOTIFY AS BEGIN DECLARE Notify_Cursor CURSOR FOR SELECT theEmp.fname+' '+theEmp.lname as fullName, tblEmployeeType.Type, tblEmployAccident.TrackingNumber, tblEmployAccident.Completed, theEmp.Email, tblAccidentInfo.staffMem, TimeOfAccident, DateOfAccident FROM tblEmployeeType, theEmp, tblEmployAccident, tblAccidentInfo WHERE tblEmployeeType.TypeID = theEmp.TypeID AND theEmp.empID = tblEmployAccident.empID AND tblAccidentInfo.TrackingNumber = tblEmployAccident.TrackingNumber AND tblEmployAccident.Completed = 0 AND DateAdd(hour, -24, getdate()) > DateOfAccident ORDER BY tblEmployeeType.TypeID DESC OPEN Notify_Cursor Declare @fullName nvarchar(50) Declare @Type nvarchar(50) Declare @trackingNumber varchar(20) Declare @Completed nvarchar(50) Declare @email nvarchar(1000) Declare @staffMem nvarchar(50) Declare @TimeOfAccident nvarchar(50) Declare @DateOfAccident nvarchar(50) -- Get the current MAX ID Declare @mailID as int -- Start reading each record from the cursor. FETCH Notify_Cursor into @fullName, @Type, @trackingNumber, @Completed, @email, @StaffMem, @TimeOfAccident, @DateOfAccident WHILE @@FETCH_STATUS = 0 BEGIN set @mailID = (SELECT max(mailID)+ 1 from notification) INSERT into notification (mailid, fullName, Type, trackingNumber, mailContent, sender, emailDate, email, Completed, staffMem, TimeOfAccident, DateOfAccident, adminName) VALUES ( @mailid, @fullName, @Type, @TrackingNumber, 'This is a computer generated email message. Please do NOT use the REPLY button above to respond to this email. Dear '+ @fullName +' Please be advised, the Accident Hotline has initiated Accident Case number '+ @trackingNumber +'. The accident occurred on '[email protected] +' at '[email protected] +' by '[email protected] +'. For more details on this case please click here: http://hq1/safe/paging.asp?trackingNumber=' @TrackingNumber '. This is an effort to efficiently and effectively track the progress of the accident information packet to be sent to Risk Management. To learn more about the steps involved with this process please click here: \c03pwpublicsafe\AcT_Report Please be advised, the following deadlines must be adhered: Step 1 is due on: '+ CAST(DateAdd(d,1,@DateOfAccident) as VARCHAR)+' Step 2 is due on: '+ CAST(DateAdd(d,2,@DateOfAccident) as VARCHAR)+' Step 3 is due on: '+CAST(DateAdd(d,3,@DateOfAccident) as VARCHAR)+' Failure to adhere to the above deadlines may result in disciplinary action. For more information, please contact the Accident Hotline at xxx-xxx-xxxx or the Safe Administrator at xxx-xxx-xxxx. Regards, The Administrator', 'admin' , getdate(), @email, 'Open', @staffMem, @TimeOfAccident, @DateOfAccident, 'admin'