how to use switch case statement in sqlserver2005 to set a value as 1 if a keyword found

Posted by Raj_chennai under Sql Server on 1/31/2012 | Points: 10 | Views : 6528 | Status : [Member] | Replies : 2
how to set the value if the keyword exists means set the value as 0 else set the value as 1 in sql server2005

raj


Responses

Posted by: harikrishna149-10896 on: 1/31/2012 [Member] Starter | Points: 25

Up
0
Down
Hi try this code

SELECT ename, salary, 'KeyWord Found'= CASE
WHEN salary=15000 THEN '1'
when salary=1600 Then '1'
ELSE '0'
END
FROM empdetails


Thanks & Regards
Hari Krishna

Raj_chennai, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bipro.reader on: 2/1/2012 [Member] Starter | Points: 25

Up
0
Down
Table Scheme ,
EmpName varchar(100), Department varchar(100), Salary numeric(18, 2), Bonus numeric(18,2)

Now calculating 'Bonus' on the basis of 'Salary' using CASE ,

UPDATE EmployeeSalary
SET Bonus = (CASE
WHEN Salary > 10000
THEN (Salary*.125)
ELSE (Salary*.25)
END)




Raj_chennai, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response