I am having invalid column name salary as the error when i try
INSERT into dbo.SelectQueries (Name,LastName,Email,Salary,Monthduration,Country,Categories)
VALUES
(
'Ted','Click','tedc@robus.co.uk',50000,2,'United Kingdom',
case when Salary >= 35000 then 'senior' ELSE 'Junior' END
)
No comments:
Post a Comment