spDiscussionGroupPosts

    CREATE PROCEDURE [dbo].[spDiscussionGroupPosts]
            (
                        @DiscussionTopicID int
            )
AS

BEGIN
            set nocount on
            select DiscussionPosts.ID,TopicID,Message,PostedByID,
            dbo.fnUserName(DiscussionPosts.PostedByID) as [FullName],
            ReplyToID,IndentLevel,PostDate,Sequence,Approved,Blocked,
            (select count(id) from DiscussionPosts DP
            where DP.TopicID = DiscussionPosts.TopicID
            and DP.IndentLevel <= DiscussionPosts.IndentLevel
            and DP.Sequence < DiscussionPosts.Sequence) as [PreviousSiblings],
            (select count(id) from DiscussionPosts DP
            where DP.TopicID = DiscussionPosts.TopicID
            and DP.ReplyToID = DiscussionPosts.ReplyToID
            and DP.IndentLevel = DiscussionPosts.IndentLevel
            and DP.Sequence > DiscussionPosts.Sequence) as [NextSiblings]
            from DiscussionPosts
            where DiscussionPosts.TopicID = @DiscussionTopicID
            and DiscussionPosts.ReplyToID is not null
            order by sequence
END