spGetCalendarEvent_DuplicateID

Parameters

Parameter	Parameter Type	Mode
@EventCalendarID	int	IN
@Category	nvarchar(100)	IN
@BeginDate	datetime	IN
@EndDate	datetime	IN
@Title	nvarchar(255)	IN

Definition

Copy



        create proc dbo.spGetCalendarEvent_DuplicateID
        (
            @EventCalendarID     int,
            @Category         nvarchar (100),
            @BeginDate         datetime,
            @EndDate         datetime,
            @Title             nvarchar(255)
        )
        as
        set nocount on
        begin
            select top 1 ID from dbo.CalendarEvent where 
                EventCalendarID = @EventCalendarID and 
                Category = @Category and 
                Title = @Title and
                datediff(ss, BeginDate, @BeginDate) <= 60 and 
                datediff(ss, EndDate, @EndDate) <= 60 
                order by ID
        end