CREATE PROCEDURE dbo.[Forum_Polls_AnswerDelete] @AnswerID INT
AS
    DECLARE @@SortOrder INT
    DECLARE @@PollID INT

    DELETE  FROM dbo.Forum_Polls_UserAnswers
    WHERE   AnswerID = @AnswerID

    SET @@SortOrder = ( SELECT  SortOrder
                        FROM    dbo.Forum_Polls_Answers
                        WHERE   AnswerID = @AnswerID
                      )
    SET @@PollID = ( SELECT PollID
                     FROM   dbo.Forum_Polls_Answers
                     WHERE  AnswerID = @AnswerID
                   )

    DELETE  FROM dbo.Forum_Polls_Answers
    WHERE   AnswerID = @AnswerID

    UPDATE  dbo.Forum_Polls_Answers
    SET     SortOrder = ( SortOrder - 1 )
    WHERE   PollID = @@PollID
            AND SortOrder > @@SortOrder

GO