need stored procedure

Iftikar Hussain13y ago

Hi,
Try like this

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

Regards,
Iftikar

Pankaj Pandey13y ago

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

Jignesh Trivedi13y ago

hi,

I think this duplicate post of
http://www.c-sharpcorner.com/Forums/Thread/220269/need-help-about-stored-procedure.aspx

so can please close it?

Sanjeeb Lenka13y ago

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