比较表中的两个日期并使用SQL返回更大的日期

Both dates are stored in one table. If date1 is greater, I want to return date1, if date2 is greater I want to return date2. I want them to be part of larger query so I would like one main query but if that is not possible, I can use a temp table and use a second query afterward. The code will be executed in a stored procedure.Both dates are stored in one table. If date1 is