Given the MERGE statement below, which is completely correct for SQL Server 2005 and later
The MERGE statement is only available in SQL Server 2008 and later.
I don't think this has any bearing on the low percentage of people getting this right, though...!