spDelete_CalendarEvent

Parameters

Parameter	Parameter Type	Mode	Description
@PKID	int	IN
@CurrentUsersID	int	IN

Definition

Copy


  CREATE   PROCEDURE [dbo].[spDelete_CalendarEvent]
@PKID int,
@CurrentUsersID int

as
begin transaction

    DECLARE @SiteContentID int
    DECLARE @AthleticEventID int
    SELECT @SiteContentID = SiteContentID, @AthleticEventID = AthleticEventID
    FROM EventCalendar c
    INNER JOIN CalendarEvent e on e.EventCalendarID = c.[id]
    AND e.[id] = @PKID

    DELETE FROM Search WHERE SiteContentID = @SiteContentID
    AND SearchInt1 = @PKID

DELETE FROM dbo.ATHLETICS_EVENTS where ID = @AthleticEventID

DELETE [dbo].[CalendarEvent] WHERE [ID] = @PKID

commit transaction