spGetCalendarEvents

Parameters

Parameter	Parameter Type	Mode
@EventCalendarID	int	IN
@BeginDate	datetime	IN
@EndDate	datetime	IN
@Category	nvarchar(4000)	IN
Definition

Copy

        CREATE     PROCEDURE [dbo].[spGetCalendarEvents]
        (
            @EventCalendarID int,
            @BeginDate datetime,
            @EndDate datetime,
            @Category nvarchar(4000)
        )
        AS
        BEGIN                
            set nocount on
            SELECT 
                [ID],
                [EventCalendarID],
                [Category],
                [CategoryName],
                [BeginDate],
                [BeginDateDisplay],
                [BeginWeekDayDisplay],
                [BeginTimeDisplay],
                [EndDate],
                [EndDateDisplay],
                [EndWeekDayDisplay],
                [EndTimeDisplay],
                [Title],
                [SubTitle], 
                [Location],
                [Details],
                [Fees],
                [MoreInfoURL],
                [ContactInfo],
                [CreatedUserID],
                [CreateDate],
                [ApprovedDate],
                [ApprovedUserID],
                [Deleted],
                [OccurenceGroupID],
                [AllDayEvent],
                [UpdateDate],
                [MapLocation],
                [Cancelled],
                [TimeZoneID],
                [RecurFrequency],
                [RecurDay],
                [RecurMonth],
                [RecurDayOfWeek],
                [RecurStartDate],
                [RecurEndDate],
                [RecurPosition],
                [RecurMonthlyMethod],
                [RecurID],
                [RecurException],
                [AthleticEventID]
            FROM dbo.fnGetCalendarEvents (@EventCalendarID, @BeginDate, @EndDate, @Category) 
            ORDER BY BeginDate, Title ASC

            RETURN    
        END