spREINT_GetEmailInfo

Parameters

Parameter	Parameter Type	Mode	Description
@MaxRecords	int	IN
@DownloadStartpoint	datetime	IN

Definition

Copy



        CREATE  PROCEDURE dbo.spREINT_GetEmailInfo 
        (
        @MaxRecords int,
        @DownloadStartpoint datetime
        )
        AS
        SET ROWCOUNT @MaxRecords 
        SELECT cumf.ID,
        cumf.ClientUsersID,
        cumf.OptedIn,
        cumf.Enabled,
        cumf.UpdateDate,
        cumf.IncomingAddress,
        cumf.ForwardingAddress
        FROM dbo.ClientUserMailForwarding cumf
        WHERE cumf.ClientUsersID IS NOT NULL
        AND cumf.UpdateDate > @DownloadStartpoint
        ORDER BY cumf.UpdateDate ASC
        SET ROWCOUNT 0