spDiscussionGroupTopics

        CREATE PROCEDURE dbo.spDiscussionGroupTopics
            (
                @DiscussionGroupID int
            )
        AS
            select DiscussionTopics.ID, DiscussionTopics.Topic,
            dbo.fnUserName(DiscussionTopics.PostedByID) as [FullName],
            DiscussionTopics.PostedByID as [ClientUsersID],
            DiscussionTopics.Replies,DiscussionTopics.LastPostDate,
            DiscussionTopics.Approved,
            DiscussionTopics.Guid
            from dbo.DiscussionTopics
            where DiscussionTopics.GroupID = @DiscussionGroupID
            order by DiscussionTopics.ID

            RETURN