Employee headcount based date of resignation

[#1]

Emp    DOJ                 DOR

10     1-Apr-2012       13-June-2014

11     11-Apr-2013      15-Apr-2014

113    12-Apr-2011    

16     11-Nov-2014

12     14-Aug-2013      13-Nov-2014

I have an employee table information.I want employee count based on Day Selection.

Suppose if i have selected 15-Apr-2014 then all the employee count should come (employee count -5)

If I have selected 16-Apr-2014 then we need to exclude Employee ID 12 from the employee count (Emp count 4)

Because 15-Apr-2014 is last day for that employee so next day he should not come in the emplyee count.

Please anyone help me to give solution..Urgent help required.

[#2]

It was very useful for me to .I did left join to remove synthetic key and It is working fine.

Thanks for your kind help

Thanks & Regards,

Ganesh

[Sameer9585]

Hi, Send me the solution if possible I am also facing the same issues