In the build-up to the release of SQL 2005, some great new features were introduced. One of these was the implementation of the mythical "Upsert" ("Update or Insert") statement. ANSI SQL:2003 defines this as the MERGE statement. When I saw this I envisioned the end to convoluted upsert...