procedure

  • Hi Friends,

    please find requirement below:

    eg: An employee's first IN is at 9.45 and last out is at 18.50 Total Hrs: T1 = 9hrs.05mts

    In between, employee spends @ canopy(cafeteria) for 30 min.& goes out of office for 55 min.

    (there may be multiple exits and entries at these doors in between first In and last out)

    Total time spent 'out' = 85 mts. Time spent out in excess of 1 hour = 85-60 = 25 mts. (T2).

    Attendance for the day = T1-T2 = 9hrs.05mts - 25mts = 8 hrs.40mts.

    Input Parameter : employee_id and from_date

    By this scenario i have to create a procedure. Pl help me on this.

  • I'd like to suggest you give this a try a first. Show us what you have tried to accomplish your task.

    However, before you do that, may I suggest that you start by first reading the first article I reference below in my signature block regarding asking for help. It will show you what you should post to get the best answers in return.

  • You could also spend some time and google for some more hints. This is a common question and there are several solutions out there.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply