petarkobakov

Get Salary Level

Feb 4th, 2023 (edited)
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE FUNCTION ufn_GetSalaryLevel(@salary DECIMAL(18,4))
  2. RETURNS NVARCHAR(20)
  3. AS
  4. BEGIN
  5. DECLARE @salaryLevel NVARCHAR(20)
  6. SELECT @salaryLevel =
  7. CASE
  8. WHEN @salary < 30000 THEN 'Low'
  9. WHEN @salary BETWEEN 30000 AND 50000 THEN 'Average'
  10. WHEN @salary > 50000 THEN 'High'
  11. END
  12. RETURN @salaryLevel
  13. END
Advertisement
Add Comment
Please, Sign In to add comment