CREATE PROCEDURE dbo.[Forum_Post_Reported_Check]
    @PostID INT,
    @UserID INT
AS
    DECLARE @ReportCount INT

    SET @ReportCount = ( SELECT COUNT(UserID)
                         FROM   dbo.Forum_Post_Reported
                         WHERE  PostID = @PostID
                                AND UserID = @UserID
                       )
    IF @ReportCount > 0
        BEGIN
            SELECT  ( 1 )
        END
    ELSE
        BEGIN
            SELECT  ( 0 )
        END

GO