"GetAnnouncements" Stored Procedure

This stored procedure returns all of the announcements for a specific Announcement module within the portal. The input parameters are ModuleID and PortalID. Only announcements whose expiration date is later than today are shown.

    
    CREATE PROCEDURE GetAnnouncements
    (
        @ModuleID int
    )
    AS

    SELECT
        ItemID,
        CreatedByUser,
        CreatedDate,
        Title,
        MoreLink,
        MobileMoreLink,
        ExpireDate,
        Description

    FROM 
        Announcements

    WHERE
        ModuleID = @ModuleID
    AND
        ExpireDate > GetDate()
        

Announcements:  Each record in the Announcements table is a single item, as displayed by the Announcements Portal Module. Since all Announcement modules store their record in this table, each item contains a ModuleID to permit related items to be retrieved in a single query.

The primary key in this table is the ItemID identity field. Note that announcement descriptions are limited to 2000 characters.