This challenge has been seen in one of the SQL Server forums. The challenge is all about merging the data based on certain conditions.