Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Employment per week

Re: Employment per week

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 12 Jun 2001 21:57:37 -0700
Message-ID: <3B26F2C1.1306063@exesolutions.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US