spNewsChannelStories

                CREATE  PROCEDURE [dbo].[spNewsChannelStories]
                (
                    @NewsChannelID int
                )
                AS
                select 
                s.ID, 
                s.Title,
                s.[Description],
                s.PublicationDate,
                s.Guid,
                s.LinkURL,
                s.Categories,
                s.LinkedPageId,
                s.LinkedPageTabId,
                s.Approved,        
                s.PostId
                from dbo.NewsStories s
                where s.NewsChannelID = @NewsChannelID
                order by s.PublicationDate desc

                RETURN