mysql

  declare  ws varchar(10);
  declare  p float(10,2);
  declare cur_ws cursor for select emp_worksheet into ws,wage into p from hsc_employee where emp_deptID='';
  declare EXIT HANDLER FOR NOT FOUND CLOSE cur_ws;
begin
  open cur_ws;
  repeat
  update bh_wage set price=p,salary=salary/price*p where workdate >='2010-06-01' and workdate <='2010-07-01' and wageType='TIME' and worksheet in(select emp_worksheet from hsc_employee where status='On')
  fetch cur_ws ;
until 0 end repeat;
close cur_channel_id;