Mind the Gaps - Partitioned Outer Joins

There are many ways developers can write code to handle sparsely populated data and fill the gaps. One method that is sometimes overlooked is the Partitioned Outer Join. The name might suggest it only works on data physically partitioned in a table, ...