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