Friday, December 26, 2014

using case function with insert

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