How to select the maximum value of multiple columns in a single row?

There is no direct function in SQL to do this. However one can use Pivot/Unpivot and dump it into a temporary
table and use the MAX function on it.