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
Pretty straight-forward....
Spoiler
Getting better at seeing when to use RecordID
Process:
- Sort by Scroogieness
- Add RecordID
- Split into Top and Bottom 25 by Scroogieness
- Resort one of the threads (so we can match most Scroogie with least Scroogie
-- New RecordID will allow the join in the right order
- Join two threads so that #1 Scroogie effectively matched to #50 Scroogie
- Calc combined score
- Clean-up
Process:
- Sort by Scroogieness
- Add RecordID
- Split into Top and Bottom 25 by Scroogieness
- Resort one of the threads (so we can match most Scroogie with least Scroogie
-- New RecordID will allow the join in the right order
- Join two threads so that #1 Scroogie effectively matched to #50 Scroogie
- Calc combined score
- Clean-up
