CREATE PROCEDURE dbo.[Forum_EmailQueue_GetPortalSendTasks]
    @PortalID INT,
    @PageIndex INT,
    @PageSize INT
AS
    DECLARE @RowStart INT
    DECLARE @RowEnd INT
            
    SET @RowStart = @PageSize * @PageIndex + 1 ;
    SET @RowEnd = @RowStart + @PageSize - 1 ;

    SELECT  *
    FROM    ( SELECT    *,
                        ROW_NUMBER() OVER ( ORDER BY QueueAddedDate DESC ) AS RowNumber,
                        ( SELECT    COUNT(EmailQueueID)
                          FROM      dbo.Forum_EmailQueue_Tasks
                          WHERE     PortalID = @PortalID
                        ) AS TotalRecords
              FROM      dbo.Forum_EmailQueue_Tasks
              WHERE     PortalID = @PortalID
            ) AS EmailQueueTaskInfo
    WHERE   RowNumber >= @RowStart
            AND RowNumber <= @RowEnd

GO