CREATE PROCEDURE dbo.[Forum_Reads_GetFirstUnread]
    (
      @ThreadID INT,
      @LastVisitDate DATETIME,
      @ViewDecending BIT
    )
AS
    CREATE TABLE #NewPostIndex
        (
          IndexID INT IDENTITY(1, 1)
                      NOT NULL,
          CreatedDate DATETIME
        )

    IF @ViewDecending = 1
        BEGIN
            INSERT  INTO #NewPostIndex ( CreatedDate )
                    SELECT  CreatedDate
                    FROM    dbo.Forum_Posts
                    WHERE   ThreadID = @ThreadID
                            AND IsApproved = 1
                    ORDER BY CreatedDate DESC
        END
    ELSE
        BEGIN
            INSERT  INTO #NewPostIndex ( CreatedDate )
                    SELECT  CreatedDate
                    FROM    dbo.Forum_Posts
                    WHERE   ThreadID = @ThreadID
                            AND IsApproved = 1
                    ORDER BY CreatedDate
        END

    DECLARE @Index INT
    SELECT  @Index = MIN(IndexID)
    FROM    #NewPostIndex
    WHERE   CreatedDate > @LastVisitDate

    SELECT  @Index AS [Index]

GO