When you need a quick mapping between column values in a SELECT statement in SQLServer, you could write a long block with UNIONS like this A bit more elegant and...