Employee Spend overtime increse salary double then norma sa

Feb 16 2016 3:58 AM
Hai to All.....
 
Write a Stored procedure in SQL Employee working more then 8 howers. Every one hower this
Salary is double than normal howers (Daily working howers is 8 howers)
 
create three tables: 1.Shifts,2.employee,3.timesheet 
Insert into shift values(emp_code  int,shift_name varchar(),shift_time time);
Insert into employee values(emp_code int,emp_name varchar(),grade varchar(),dept varchar(),  salary int); 
Insert into timesheet values(emp_code int,date _in date,time_in time,time_out time,date_out date);
 Using above Three table  and write SP
Example: 
 Per day normal working howers is :8 howers
per howers salary 100 rupes
Daily salary =8*100=800
Spend extra 1 hower =1*100 (normal salary)+salary double
                                      =1*100+100=200
Spend extra 2 howers=2*100 (normal salary)+salary double
                                      =2*100=200+200(salary double)=400
Plz Send Stored procedure in SQL ((Using above  Three Tables))
 
Thanks and regard's
 
Venkatesh D 
 
 

Answers (6)