spDiscussionPosts_SetBlock

        CREATE PROCEDURE [dbo].[spDiscussionPosts_SetBlock]
        (
            @PKID int,
            @blocked bit
        )

AS

BEGIN
set nocount on
begin transaction

declare @SiteContentID int

select @SiteContentID = dg.SiteContentID
from discussionposts dp
inner join discussiontopics dt on dt.id = dp.topicid and dp.id = @PKID
inner join discussiongroups dg on dg.id = dt.groupid

update [dbo].[discussionposts]
set blocked = @blocked
where id = @PKID

delete from Search where SiteContentID = @SiteContentID
and SearchInt1 = @PKID

commit transaction

END