using case function with insert

INSERT INTO dbo.SelectQueries (Name,LastName,Email,Salary,Monthduration,Country,Categories)
VALUES ('Ted','Click','tedc@robus.co.uk',50000,2,'United Kingdom','Senior')

OR

DECLARE @Salary money
SET @Salary = 50000

INSERT INTO dbo.SelectQueries (
         Name
        ,LastName
        ,Email
        ,Salary
        ,Monthduration
        ,Country
        ,Categories
)
VALUES (
        'Ted'
        ,'Click'
        ,'tedc@robus.co.uk'
        ,@Salary
        ,2
        ,'United Kingdom'
        ,CASE WHEN @Salary >= 35000 THEN 'Senior' ELSE 'Junior' END
)

---

A Fan of SSIS, SSRS and SSAS