spLoadRecord_CalendarEvent

  CREATE  PROCEDURE [dbo].[spLoadRecord_CalendarEvent]
        (
            @PKID int,
            @RecurID int
        )
        AS

            set nocount on

                SELECT    [ID], [EventCalendarID], [Category], 
                        [CategoryName] =    
                            Case Category 
                                When '' Then ''
                                Else (SELECT dbo.fnGetSiteCodeTableEntryDescription(1, Category))
                            End, 
                        [BeginDate] = 
                            Case 
                                When @RecurID = 0 Then c.BeginDate
                                Else r.BeginDate
                            End,
                        dbo.fnFormatDateTime(case when @RecurID = 0 then c.BeginDate else r.BeginDate end, 'MM/DD') as [BeginDateDisplay],
                        dbo.fnFormatDateTime(case when @RecurID = 0 then c.BeginDate else r.BeginDate end, 'WEEKDAY') as 

[BeginWeekDayDisplay],
                        dbo.fnFormatDateTime(case when @RecurID = 0 then c.BeginDate else r.BeginDate end, 'HH:MM 12') as 

[BeginTimeDisplay],
                        [EndDate] = 
                            Case 
                                When @RecurID = 0 Then c.EndDate 
                                Else r.EndDate
                            End,
                        dbo.fnFormatDateTime(case when @RecurID = 0 then c.EndDate else r.EndDate end, 'MM/DD') as 'EndDateDisplay',
                        dbo.fnFormatDateTime(case when @RecurID = 0 then c.EndDate else r.EndDate end, 'WEEKDAY') as 

'EndWeekDayDisplay',
                        dbo.fnFormatDateTime(case when @RecurID = 0 then c.EndDate else r.EndDate end, 'HH:MM 12') as '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] = 
                            Case 
                                When @RecurID = 0 Then 0
                                Else r.RecurID
                            End,
                        [RecurException],
                        [AthleticEventID]
                FROM CalendarEvent c
                LEFT OUTER JOIN dbo.CalendarEvtRecur r ON r.EventID = c.ID and r.RecurID = @RecurID
                WHERE c.ID = @PKID
            Return