CREATE PROCEDURE dbo.[Forum_Post_GetEntireThread] @ThreadID int
AS
    SELECT  PostID,
            ParentPostID,
            UserID,
            RemoteAddr,
            [Subject],
            Body,
            CreatedDate,
            ThreadID,
            UpdatedDate,
            UpdatedByUser,
            IsApproved,
            IsLocked,
            IsClosed,
            DateApproved,
            PostReported,
            Addressed,
            ParseInfo,
            ( SELECT    COUNT(PostID)
              FROM      dbo.Forum_Posts
              WHERE     ThreadID = @ThreadID
            ) AS TotalRecords
    FROM    dbo.Forum_Posts P
    WHERE   P.ThreadID = @ThreadID
    ORDER BY CreatedDate DESC

GO