SQL SERVER – Explanation SQL SERVER Merge Join | Journey to SQL Authority with Pinal Dave

The Merge Join transformation provides an output that is generated by joining two sorted data sets using a FULL, LEFT, or INNER join. The Merge Join transformation requires that both inputs be sorted and that the joined columns have matching meta-data. User cannot join a column that has a numeric data type with a column… Continue Reading...

Source: SQL SERVER – Explanation SQL SERVER Merge Join | Journey to SQL Authority with Pinal Dave