fnEventCalendarDateHasEvents

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@EventCalendarID	int	IN
@Date	datetime	IN

Definition

Copy




CREATE  FUNCTION dbo.fnEventCalendarDateHasEvents
    (
    @EventCalendarID int,
    @Date datetime
    )
    Returns int
    AS
    BEGIN

        Return 
        (
        select Count(*) from CalendarEvent where 
        EventCalendarID = @EventCalendarID
        AND

        (
        dbo.fnResetTimeForDate(@Date) >= dbo.fnResetTimeForDate(BeginDate)
        AND
        dbo.fnResetTimeForDate(@Date) <= dbo.fnResetTimeForDate(EndDate)
        )

        )
    END