Get aggregations of few columns for each record - using 'Values' operator

SELECT ValuesTestID, ValuesTestName, 

IntCol1, IntCol2, IntCol3, IntCol4, IntCol5, IntCol6,

( Select MAX(ValuesTestName)

From    (Values (IntCol1), (IntCol2), (IntCol3), (IntCol4), (IntCol5), (IntCol6)) 

UniqueColumn(ValuesTestName)

) MaxIntCol,

( Select SUM(ValuesTestName)

From    (Values (IntCol1), (IntCol2), (IntCol3), (IntCol4), (IntCol5), (IntCol6)) 

UniqueColumn(ValuesTestName)

) SumIntCol

FROM ValuesTest