Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Employment per week
Vladimir Ivanovich wrote:
> Hi,
>
> I need to create a report that counts employees for each week.
> The output should look like this:
>
> Week_Start Week_End Emp_Count
> ********************************
> 05/27/2001 06/08/2001 42
> 06/03/2001 06/09/2001 44
> 06/10/2001 06/16/2001 44
>
> etc.
>
> The Emp table has emp_num, Emp_name, Start_date and Term_Date along with the
> rest.
> Only full employment weeks should be counted for each employee.
>
> Thanks in advance,
> Vladimir
Hopefully you don't expect someone to create the report for you. Seems to me you are being paid for this. Right?
Give us a specific question or an example of what you have done and we can offer help. But to do your work for you ... I think you would need to make financial arrangements. Maybe latte's for everyone whose posted during the last week. <g>
Daniel A. Morgan Received on Tue Jun 12 2001 - 23:57:37 CDT