Need help about stored procedure

Question

Hi...

Iam abhilash ..

 

suppose we have 4 fields .. like Empid ,Name,Salary,NetPay..

who's employees earn < 5000 salary those people get 10% comission so that employees salary +comission ..updated into NetPAy column in same table four fields..

i need stored procedure ....