Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
For some reason I couldn't get my head around this challenge so here is my rather overcomplicated solution
:-) this is good stuff - we do this particular challenge all the time in real life!
Spoiler
- Bring in the new rows first into the union
- Add a record ID in-case some new rows have same info (e.g. Bob)
- Set the end-dates by using start date of the newer record
- Set the current flag using a unique tool taking only most recent
- Then remove people who have left completely (latest = y; but end-date exists)
- Bring in the new rows first into the union
- Add a record ID in-case some new rows have same info (e.g. Bob)
- Set the end-dates by using start date of the newer record
- Set the current flag using a unique tool taking only most recent
- Then remove people who have left completely (latest = y; but end-date exists)
