Try this:
ALTER PROCEDURE dbo.ManageLaborEval
(
@a int,
@b int,
@c int
)
AS
BEGIN
Declare @sum bigint;
Set @sum = @a + @b + @c;
Declare @Evaluation NVARCHAR(30);
IF @sum = 12
BEGIN
Set @Evaluation = 'Perfect';
END
ELSE
BEGIN
Set @Evaluation = 'weak';
END
INSERT INTO Table1(a, b, c, total, evaluation) VALUES (@a,@b,@c, @sum, @Evaluation)
END
Hope it helps,
Azee...