SQL Query -

  • Posted
  • Proposals 1
  • Remote
  • #28949
  • Archived
Jiju J. has already sent a proposal.
  • 0

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

Clarification Board

    There are no clarification messages.