Try with
BEGIN ... END
code block ;)
CREATE PROCEDURE InsertEmployeeBenefitsDeducts
(
@BranchID bigint,
@EmployeeID bigint,
@BenefitDeductionID bigint,
@AffectOnLeave bit,
@Amount decimal(18,4),
@CreatedUserID bigint,
@CreatedDate datetime,
@ModifiedUserID bigint,
@ModifiedDate datetime
)
AS
BEGIN
DECLARE @EmpBenefitDeductID as bigint
SELECT @EmpBenefitDeductID=ISNULL(MAX(EmployeeBenefitsDeducts.EmpBenefitDeductID),0)FROM EmployeeBenefitsDeducts
SET @EmpBenefitDeductID=@EmpBenefitDeductID+1
INSERT INTO EmployeeBenefitsDeducts (EmpBenefitDeductID, BranchID, EmployeeID, BenefitDeductionID, AffectOnLeave, Amount, CreatedUserID, CreatedDate, ModifiedUserID, ModifiedDate)
VALUES (@EmpBenefitDeductID, @BranchID, @EmployeeID , @BenefitDeductionID , @AffectOnLeave , @Amount , @CreatedUserID , @CreatedDate , @ModifiedUserID , @ModifiedDate)
SELECT @EmpBenefitDeductID AS EmpBenefitDeductID
END