CREATE PROCEDURE dbo.[Forum_User_GetBanned]
    @PortalId INT,
    @PageIndex INT,
    @PageSize INT
AS
    BEGIN
        DECLARE @PageLowerBound INT
        DECLARE @PageUpperBound INT
        SET @PageLowerBound = @PageSize * @PageIndex
        SET @PageUpperBound = @PageSize - 1 + @PageLowerBound

        CREATE TABLE #PageIndexForUsers
            (
              IndexId INT IDENTITY(0, 1)
                          NOT NULL,
              UserId INT
            )

        INSERT  INTO #PageIndexForUsers ( UserId )
                SELECT DISTINCT
                        ( UserId )
                FROM    dbo.Forum_Users
                WHERE   ( PortalId = @PortalId )
                        AND IsBanned = 1

        SELECT  U.UserID,
                U.Username,
                U.DisplayName,
                LiftBanDate,
                StartBanDate
        FROM    dbo.Forum_Users FU
                INNER JOIN dbo.Users U ON FU.UserID = U.UserID
                INNER JOIN #PageIndexForUsers P ON U.UserID = P.UserID
        WHERE   U.UserId = P.UserId
                AND ( PortalId = @PortalId )
                AND P.IndexId >= @PageLowerBound
                AND P.IndexId <= @PageUpperBound
                AND IsBanned = 1
        ORDER BY StartBanDate DESC

        SELECT  TotalRecords = COUNT(*)
        FROM    #PageIndexForUsers

    END

GO