"Troubleshooting Errors in SQL Stored Procedure for Calculating Employee Bonuses"

khanzain

"I'm working on a stored procedure that calculates employee bonuses, but there's a hiccup. Can you pinpoint the error in the code provided?

CREATE PROCEDURE CalculateSalary

  @EmployeeID INT,

  @BonusPercentage DECIMAL(5, 2) OUTPUT

AS

BEGIN

  SELECT INTO @BonusPercentage = Salary * 0.1

  FROM Employees

  WHERE EmployeeID = @EmployeeID;

END;"

Genevieve P.

Hi @khanzain

Is your question regarding the Smartsheet application? This looks to be more of a programming question. I would recommend posting in a developer forum, such as Stack Overflow: https://stackoverflow.com/

Cheers,

Genevieve