"GetEvents" Stored Procedure

This stored procedure returns all of the events for a specific Events module within the portal. The input parameter is the ModuleID. Only event whose expiration date is later than today are shown.

		
   CREATE PROCEDURE Portal_GetEvents
   (
       @ModuleID int
   )
   AS
   
   SELECT
       ItemID,
       Title,
       CreatedByUser,
       WhereWhen,
       CreatedDate,
       Title,
       ExpireDate,
       Description
   
   FROM Portal_Events
   
   WHERE
       ModuleID = @ModuleID
     AND
       ExpireDate > GetDate()
        

Events:  Each record in the Events table is a single item, as displayed by the Events Portal Module. Since all Events 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 event descriptions are limited to 2000 characters.