Need help about stored procedure

Hi,
Try like this

update Emptable
set Netpay=CASE WHEN salary<5000 THEN Netpay+((salary*10/100))
ELSE Netpay end

Regards,
Iftikar

create procedure p_name
as
begin
update tablename
set salary= case
when salary< 5000 then salary * 1.1
else salary
end
end

hi,

try

CREATE PROCEDURE TempSP
AS
BEGIN
update Table1
set NetPay = salary + (salary *10)/100
where salary <=5000
END

hope this will help you.

you can use this :

CREATE PROCEDURE hike
AS
BEGIN
UPDATE yourtablename
SET NetPay = CASE
WHEN Salary < 5000 THEN Salary * 1.1
ELSE Salary
END
END