Hi guys,
I have three table in sql server,
[job, emp & emp_history]
once the job is created the user can assign employees to the job
n
before the job is closed the user can assign more employees or can remove assigned employees.
here the problem is, how to maintain Starting date n Ending date of an employee,
in both of these tables[emp n emp_history] i have these two columns (starting date n ending date)
because, i have to display it in one repeater by merging both the tables[emp n emp_history].
the repeater look like this,
--------------------------------------------------------------
jobID | Emp-ID | Emp-Name | Starting Date | Ending Date |
--------------------------------------------------------------
1 | 01 | ABC | 08/01/2014 | 08/30/2014 |
--------------------------------------------------------------
2 | 02 | DEF | 08/01/2014 | 08/15/2014 *|
--------------------------------------------------------------
3 | 03 | GHI | 08/16/2014 * | 08/30/2014 |
--------------------------------------------------------------
can anyone plz help me,
Thanks