Posted - 04/23/2013 : 09:27:44
| http://s367.photobucket.com/user/tuansaker3291/media/Capture-2_zps6ab4100b.jpg.html]" target="_blank">Databases have this form, sir: br / [url=http://s367.photobucket.com/user/tuansaker3291/media/Capture-2_zps6ab4100b.jpg.html]
1 I have a database like this, the employee's pay is calculated as follows
(luongcoban port number *) * + khenthuong heso - kyluat - tamung
The problem is that the code queries the employees, month and year, let's assume it is manhanvien @ variable, @ @ stairs and turn men away
The next problem is with tiencong table, chamcong, tamung the day, month, and employee code only appears one time simultaneously, but separately, the reward and discipline to be able to reward disciplined several times in 1 month should be to get the total amount of reward and discipline by month and year to be able to enter into payroll formula on the other.
So do not know, this recipe is mixing what type of SQL statement: D
Payrolls it this
sorry for my english is not good!