spREINT_GetFundRaiserEmailsInfo

            CREATE PROCEDURE dbo.spREINT_GetFundRaiserEmailsInfo
            (
            @MaxRecords int,     
            @DownloadStartpoint datetime
            )
            AS
                SET ROWCOUNT @MaxRecords                              
                SELECT DISTINCT                                       
                    cu.ID as "ClientUsersID",
                    fr.BackOfficeID as "BackOfficeFundRaiserID",                                                                                                  ejr.EmailRecipientID,
                    ejr.UpdateDate
                FROM  dbo.FundRaiserSolicitorEmail frse
                INNER JOIN dbo.EmailJob_Recipient ejr on ejr.EmailJobID = frse.EmailJobID
                INNER JOIN dbo.EmailJob ej on ej.EmailID = ejr.EmailID
                INNER JOIN dbo.FundRaiserSolicitors frs on frs.ID =  frse.FundRaiserSolicitorsID 
                INNER JOIN dbo.Email e on e.ID = ej.EmailID
                INNER JOIN dbo.FundRaiserEmail fre on fre.emailTemplateID = e.emailTemplateID
                INNER JOIN dbo.FundRaisers fr on fr.Id = fre.FundRaisersID
                INNER JOIN dbo.ClientUsers cu on cu.ID = frs.ClientUsersID                             
                WHERE ClientUsersID is NOT NULL and fr.BackOfficeID is NOT NULL 
                AND ejr.EmailRecipientID is NOT NULL and (ejr.UpdateDate > @DownloadStartpoint)
                SET ROWCOUNT 0