SQL Query -
5053
$$
- Posted:
- Proposals: 1
- Remote
- #28949
- Archived
Description
Experience Level: Intermediate
We use multiple other codes in addition to the annual leave codes for different whereabouts.
I'll limit the example to one additional code:
WH Working from home for full day
WHAM Working from home for the morning
WHAPM Working from home for the afternoon
It is possible to combine 2x half days of different codes to make a full day.
DB example:
Userid CalendarDate Type Return_to_work
1 2010-06-30 WH 2010-07-02
1 2010-07-01 ALAM 2010-07-02
1 2010-07-01 WHPM 2010-07-02
Attached is a revised version of your SP which includes the additional codes and a restriction on the dates checked.
Can you amend the code accordingly
I'll limit the example to one additional code:
WH Working from home for full day
WHAM Working from home for the morning
WHAPM Working from home for the afternoon
It is possible to combine 2x half days of different codes to make a full day.
DB example:
Userid CalendarDate Type Return_to_work
1 2010-06-30 WH 2010-07-02
1 2010-07-01 ALAM 2010-07-02
1 2010-07-01 WHPM 2010-07-02
Attached is a revised version of your SP which includes the additional codes and a restriction on the dates checked.
Can you amend the code accordingly
Tim H.
100% (4)Projects Completed
5
Freelancers worked with
4
Projects awarded
71%
Last project
16 Jan 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies