spDelete_DiscussionTopics

CREATE   PROCEDURE dbo.spDelete_DiscussionTopics
(
    @PKID int    ,
        @CurrentUsersID    int

)
AS

declare @Guid uniqueidentifier

begin transaction

    SELECT @Guid = Guid from DiscussionTopics where ID = @PKID

    DECLARE @SiteContentID int
    SELECT @SiteContentID = SiteContentID 
    FROM DiscussionGroups g
    INNER JOIN DiscussionTopics t on t.GroupID = g.[id]
    AND t.[id] = @PKID

    DELETE FROM Search 
    WHERE SiteContentID = @SiteContentID and SearchInt1 IN 
    (SELECT ID FROM DiscussionPosts WHERE TopicID = @PKID)

    DELETE FROM DiscussionTopics where ID = @PKID

    if not @Guid is null exec spAuditThis @CurrentUsersID, 3, @Guid, 21

commit transaction