spREINT_GetFundRaiserCommentsInfo

            CREATE  PROCEDURE [dbo].[spREINT_GetFundRaiserCommentsInfo]
            (
            @MaxRecords int,
            @DownloadStartpoint datetime
            )
            AS
            SET ROWCOUNT @MaxRecords
            SELECT
            dt.DonationTransactionsID,
            cu.ID As "ClientUsersID",
            dt.XMLObjectData As "XMLObjectData",
            '' As "Comments",
            '' AS "DonorFirstName",
            '' AS "DonorLastName",
            dbo.fnFundRaiserPageHits(frs.ID) As "PageHits",
            dbo.fnFundRaiserSolicitorPageID(frs.ID) As "PageID",
            frt.backofficeID as "TeamBackOfficeID",
            ''As "URL",
            dt.processed_date,
            dt.emailid,
            dt.AddedByUserID,
            frdt.isOffline "IsOffline",
            frs.ID "SolicitorID"
            FROM
            donationtransactions dt
            LEFT JOIN
            Fundraiserdonations frdt on frdt.DonationTransactionsID = dt.DonationTransactionsID
            LEFT JOIN
            FundRaiserSolicitors frs on frs.ID = frdt.SolicitorID
            LEFT JOIN
            ClientUsers cu on cu.ID = frs.ClientUsersID
            LEFT JOIN
            FundRaiserTeams frt on frt.ID = frs.TeamID
            Where dt.Status = 1 and (dt.processed_date is not null) AND (dt.DateAdded > @DownloadStartpoint)
            SET ROWCOUNT 0